

- Temporary system restarts and downtime
- Slow performance
- Failed requests
Reducing RAM Usage
If you are finding yourself in a situation where you are experiencing symptoms of RAM exhaustion, there are a few things you can to do try and mitigate the situation.CommentIt’s important to note that in some cases, when mitigation is not possible, that may signal it’s time to upgrade your Xano subscription tier to increase your available RAM. You can always reach out to Xano Support for further clarification.C Database RAM Spikes in Database RAM can be caused by one or more of the following:-
Tables that contain fields with large amounts of data, such as JSON payloads or sizable text content
- Try moving these large fields to a separate table or determining if you can reduce the amount of data stored.
- Depending on how often the data needs to be accessed, you can also store the large data in text files and store the file path in the table instead.
-
Table references to other tables with a high number of fields
- Use the Auto Complete setting on the referenced table to reduce the amount of data loaded when viewing the table
-
Running queries with joins on large tables
- Make sure you are using proper indexing on large tables
- Use pagination on your base query
-
Function stacks that process large volumes of data
- Clear the contents of variables as they become unnecessary by updating them to blank values
- Move large data processing jobs to background tasks
- Use post processing to execute any functions that aren’t necessary to deliver a response
- Contents of other variables are too large for the Lambda to handle during processing
- Using file resources in conjunction with Lambdas
- Heavy and/or inappropriate reliance on data caching functions