Optimize SQL query

mahdy_sharifi

• November 25, 2013 05:46

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

  • November 25, 2013 17:05

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

  0
• 

  mahdy_sharifi

  • November 25, 2013 17:18

  for every SLOW query should get help from script developer ?

  0
• 

  MikeDVB

  • November 25, 2013 17:22

  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.

  0

Please sign in to leave a comment.