Optimizing Webhooks and Database Performance for Xano and Weweb
In this meeting, the participants discuss the performance issues related to sending a campaign to a large number of people. They identify that there is a delay in processing the campaign due to the high volume of delivered calls. They suggest diagnosing the issue by commenting out everything and checking if the problem persists. If the problem persists, they recommend using a webhook relay service designed for caching and batching requests. However, if the issue is with the webhook itself, they suggest optimizing it by storing the input in a database and processing it in a background task. They mention that using database transactions can improve efficiency in handling multiple requests. They also mention the possibility of using Redis, an in-memory store, for even faster performance. The participants acknowledge that the solution may vary depending on the plan they are using and suggest seeking support from Xano for further guidance. Overall, they prioritize the need for diagnostics, testing different solutions, and planning for short-term and medium-term improvements.