Performance Tuning
The Performance Tuning page helps you optimize your site’s database performance by analyzing slow queries and suggesting database indexes. Applying the recommended indexes can reduce query execution time, improve response speed, and lower database CPU usage.
Before adding new indexes, review your site’s slow queries from the Performance Tuning page. Database indexes are most effective for queries that are executed frequently or take a long time to complete.
Add a Database Index
- Open the Performance Tuning page from your site dashboard.
- Select the slow query you want to analyze. This opens the Normalized Slow Query dialog.
- Click Analyze Query. The analysis starts in the background, and a notification confirms that the process has begun.
- Wait for the analysis to complete. Depending on the size of the query and database tables, this may take anywhere from 10 seconds to 5 minutes.
- Once the analysis finishes, review the suggested database index, if one is available.
- Click Apply Suggestion to create the recommended database index.
- You can monitor the progress of the index creation from the Jobs tab.
- Only one query analysis can run at a time because the process is CPU-intensive.
- Only one database index can be created at a time for a site.
If No Index Is Suggested
If the query analyzer cannot recommend an index, it means an automatic optimization is not available for that query. In such cases, you may need to review the query manually and create appropriate database indexes based on your application’s filtering and sorting requirements.
Apply indexes only to queries that are executed frequently or consume significant CPU time. While indexes improve read performance, creating too many unnecessary indexes can slow down insert, update, and delete operations.
