Chartio runs its queries on the databases it’s connected to, so the server will take the additional load of those queries. We do many things to minimize that potential load:
- All queries are dirty unlocking reads
- Caching of results at your set interval (default five minutes)
- Queuing of query results if multiple people are requesting the query at the same time
If you are concerned about an additional load to your database, we recommend adding more memory, creating a replica or running off of a backup database if you are not already. For more information, see our tips for improving query performance.