My site is taking a Full minute to load due to slow queries?

Question

My Magento Site , using a Theme, is taking a Full Minute to load up !!

The Host Provider has advise its due to SLO"W QUERIES. I'm using a 4GB RAM Server, so dont think it's the problem.

Optimising the Tables has not resolved the problem.

Does anyone know if the the "Full Page Cache" Extensions will resolve the problem ?

Or is the Theme Template faulty ?

I really like the Theme since it's best suited to the business model & want to continue using it.

How can i resolve the issue of SLOW QUERIES ?

Pls help.

Answer 1

To be able to see which queries are slow, you can edit the following file lib/Varien/Db/Adapter/Pdo/Mysql.php

And change the following variable to true:

protected $_debug               = true;

The slow queries will be logged under the var/debug/pdo_mysql.log file.

You can change the query durations to be logged by changing the following variable:

protected $_logQueryTime        = 0.05;