Improving Performance for Xano's Survey Engagement Tool
In this meeting, the State Changers discuss a performance issue with an API responsible for generating reports on survey questions. They find that the query is taking longer to execute, causing delays in the front-end user experience. Yash suggests using caching to improve performance. They discuss two types of caching: lazy caching (caching the first request and responding quickly to subsequent requests) and aggressive caching (running a background task to generate caches and delivering cached results). They also mention the possibility of introducing indexing to speed up queries. Yash agrees to explore caching and play around with it, while also considering how to incorporate user adjustments and fine-tuning of data into the caching process. The meeting ends with Yash expressing gratitude and the State Changers planning to continue working on the issue.