Robert Granlund
asked on
What is the normal amount of queries
I'm not sure on how to ask this question;
If I have an enterprise level website and I am using a content management system that builds the pages dynamically, what is an acceptable amount of queries to build a page?
Nake sense?
If I have an enterprise level website and I am using a content management system that builds the pages dynamically, what is an acceptable amount of queries to build a page?
Nake sense?
Your question makes sense... but I don't think it is necessarily the "right" question... there is no set standard for the number of queries... there are many factors that influence the number of queries that may run on a page. For example:
- number of queries does not itself indicate a bottlneck i.e. running 100 super fast queries vs running 10 queries that need a minute each to complete
- a page maybe composed of several different widgets, each widget might run it's own SQL, and it might not be possible to reduce the number of queries
- some of these widgets might cache output, and only actually execute against the database at seemingly "random" times, so to generate the same page might be a result of different numbers of hits on the database, even on consecutive visits to this page
I think, it's better to try an understand "why" you are wondering about the number of queries. Are you having performance issues? Is this a proprietary CMS or is this something like WordPress? Is it possible to "benchmark" the performance of your CMS implementation against other implementations of the same CMS - e.g. if WordPress, are other WordPress sites offering similar features to your site performing much faster than yours? How good is your hosting platform - hardware, load balancing, etc?
- number of queries does not itself indicate a bottlneck i.e. running 100 super fast queries vs running 10 queries that need a minute each to complete
- a page maybe composed of several different widgets, each widget might run it's own SQL, and it might not be possible to reduce the number of queries
- some of these widgets might cache output, and only actually execute against the database at seemingly "random" times, so to generate the same page might be a result of different numbers of hits on the database, even on consecutive visits to this page
I think, it's better to try an understand "why" you are wondering about the number of queries. Are you having performance issues? Is this a proprietary CMS or is this something like WordPress? Is it possible to "benchmark" the performance of your CMS implementation against other implementations of the same CMS - e.g. if WordPress, are other WordPress sites offering similar features to your site performing much faster than yours? How good is your hosting platform - hardware, load balancing, etc?
ASKER
Im using Expression Engine
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
After rereading your question the answer is "Whatever it takes to display the information needed to the end user in a short period of time to where the user doesn't lose interest or patience in waiting for the data/content.".
You might check out articles like:
https://blog.kissmetrics.com/speed-is-a-killer/
You might check out articles like:
https://blog.kissmetrics.com/speed-is-a-killer/
You will want to do an analysis of your queries costs and see what indices might improve your performance. It could take some time and someone with lots of SQL knowledge would be valuable asset.
Otherwise your question is really subjective.
What CMS are you using?