(This is taken directly from our Xano documentation -- see the full version here.)
Debugging Performance Issues
There are several variables to look at when addressing performance issues, including:
The volume of API requests and the time between them
The complexity of the business logic
The amount of data being sent/received.
[Note: If your instance hits maximum usage, reported statistics may no longer be accurate.]
Start by taking a look at your API request history to search for any endpoints that are taking longer than expected. As a good rule of thumb, any request that the user has to wait for should be no longer than 5 seconds. Things that are processing more data should be moved to a background task and cached for a user to view it later.
To view the request history and sort by duration, head over to your workspace dashboard and click Details next to API requests, and you can easily filter by a time you specify.
Accessing the Request History
To address slower performance, you should also consider applying a database index. An index allows you to quickly search through a table by specifying the field or fields you are searching on, without searching the entirety of every record. This type of performance issue is typically identified by high database load in the resource graph on your dashboard.
In addition to indexing, data caching features are a robust solution for faster response times. Please check your Xano plan for availability of these features. More on those here.
If you have already addressed efficiency concerns in your database and function stacks, the next step is to upgrade your Xano plan for improved performance.