Queries and Databases
Optimizing queries and databases.Discuss in our Forum Discuss in Slack
This page provides information on optimizing queries, query caching (when you should, and shouldn't use it), and database optimization techniques.
This section provides information on available tools and techniques to optimize queries.
Query caching can improve optimization. Read the sections below to learn more about when you should, and when you shouldn't use query caching.
Bust Cache with Query Parameter
Include static files with cache-busting query strings. This prevents the long
Upload Entirely New Files
For files included in pages without cache-busting query strings (like images), it's better to upload a new file (and delete the old one) instead of replacing the existing file.
The new filename will cause clients to get the new file, even if they have a cached version of the older one (which is likely given the one-year cache lifetimes for static files on Pantheon).
Optimizing your database can increase site performance. Learn more about Drupal and WordPress guidelines for improving database optimization.