Number of MySQL queries per page
Permalink
Our C5 site seems to generate a very large number of queries per page load, over 1000.
I can't believe this is normal behaviour so I assume our developers have introduced some inefficient blocks or bugs.
Is there a way I can debug C5 to see where the most queries are coming from? It would be good to see query stats per block but even per page would be helpful.
I can't believe this is normal behaviour so I assume our developers have introduced some inefficient blocks or bugs.
Is there a way I can debug C5 to see where the most queries are coming from? It would be good to see query stats per block but even per page would be helpful.
System and settings/Environment/Logging Settings
Check two options
- Log Database Queries
- Clear Query Log on Reload
Now, on every page request, table "SystemDatabaseQueryLog" will be populated with db queries.