MySQL Query Optimization Strategies

[JazyLcan]

Hi again,
I have several queries running on my site and being on a shared plan I am becoming more and more aware that optimizing these queries is essential to the efficient running of my site. Can anyone suggest to me some ways in which I can optimize my queries and in general have my MySQL database running efficiently.

[BigAlReturns]

Basically you need to normalise your database, and then run as few and as efficient queries as possible. You can find out how long your queries take to run using microtime as below:

PHP Code:

$starttime=microtime();
// run query
echo ($starttime - microtime()); 


To help you optimise specific queries we'd need to see your DB structure and the queries you're currently using.