Hello, in order to reduce database high usage I’ve applied all the recommendations I’ve found here:

http://expressionengine.com/wiki/Reduce_Queries/

I’ve created an EE blank template to check if I’ve got only 4 queries as the wiki says, though it is using 9. I think some of them should not appear and I’d like somebody help me to avoid them. Here are some questions:

1. “Don’t run sessions. Use cookies only. (session preferences) “. I’m not using but I can see this query, is it OK?

2. As the template is blank, why does EE search for global variables?

Thank you.

Now, I’m just guessing here, but how would you check to see if global variables have been used without first knowing what global variables are available?

Ok I do understand your point about the template being completely blank, but in a real world scenario when are you going to be serving blank templates?

I guess to save on memory, EE could first just grab the variable_name values rather than the complete data set but doing so will then require 2 queries. Personally I wouldn’t worry too much about that simple select statement.

Like the_butcher says, I’m not sure how you could realistically avoid checking for globals.  And it isn’t much of a query, so I can’t see hacking it out if you knew you’d never use globals.  (Also keep in mind- I’m not dead sure it can be reduced to 4 queries on 1.6.  So that may/may not be a factor.)

As for the session bit- I do be it might be ditchable.  Are you using cookies only for both frontend and backend?

I know it’s a simple statement, but when you’ve got half million daily pageviews the database hangs the server and every little improvement will be productive.

Robbie, do you mean Control Panel Session Type and User Session Type? Both use only cookies.

On the globals?  Only thing I can think is to request a user configurable to turn it off.  Or a hack.  The sessions check- I’ll have to ask the crew if it’s required or not.  But if you’re using cookies on both and have disabled the stats?  I’m not sure why it’s required.  Might be, but I can’t tell for sure.

Yes, I diableb sessions on both and the stats are disabled.

I can’t help but think that if a blank page is not loading instantly, you have a server infrastructure issue.  Have you discussed your speed problems with your host? Perhaps your hosting plans needs to go up a notch to handle your traffic?

I don’t see problems with speed. The only problem is that ee queries collapse the db and hangs the server. I can’t say now it’s features but it’s a good server. We acquired it this august.