Optimize SQL query

[mahdy_sharifi]

Hi :

How Can optimize Slow query ? for example we have any slow query on our server but how can optimize it ?

# Query_time: 10.734189  Lock_time: 0.000084 Rows_sent: 1  Rows_examined: 656958
SET timestamp=1385379910;
SELECT COUNT(c.c_id) AS confirmed, (SELECT COUNT(p.post_id) FROM nuke_bb3posts AS p WHERE (p.post_id = '5462281' AND p.poster_id = '1')) AS allowconfirm FROM nuke_bb3c
onfirms AS c WHERE (c.post_id = '5462281' AND c.confirmer_id = '1');

Thank You

 

[MikeDVB]

I would advise you to get with the script developer for assistance on optimizing their SQL Queries.

 

[mahdy_sharifi]

for every SLOW query should get help from script developer ?

 

[MikeDVB]

cPanel isn't generating the queries - cPanel is just a control panel.

For example - if you were to uninstall the script - you will see no more slow queries from it even though cPanel is still installed and working.

In short - contact the script developer responsible for crafting the query and not the control panel that runs on the server.

Hopefully this makes sense for you.