This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
June 28, 2014 3:04pm
Subscribe [3]#1 / Jun 28, 2014 3:04pm
I get average of 90-100 queries on every single page on my sites so called “basic” page. What can I do to reduce those to minimum. I’ve used channel:entries disable but still pages make too much queries.
I have never before looked at this so would be happy for a little help what to do to reduce them, thanks.
#2 / Jun 30, 2014 3:30am
Have you turned on template caching?
It’s also worth looking at things like conditionals and embeds if you are using those to see if they can be used more efficiently.
#3 / Jun 30, 2014 3:17pm
Havent cached anything yet. I try to see if there is something with conditionals and try to cut out something 😊
#4 / Jun 30, 2014 7:02pm
Until EE 2.9.0 (still not released) conditionals can be a big problem. Complex conditionals would always parse very late in the parse order, which means that everything inside the complex conditional would parse, and then the complex conditional would decide what to display. This is inefficient and could cause unnecessary queries.
You might also try disabling certain things that you do not need, like pagination or member data, in your channel entries tag to improve efficiency.