UBB.Developers Forums Community Development Programming MySQL and Server Configuration Slow Mysql Querys

  <br /># Query_time: 243  Lock_time: 208  Rows_sent: 1  Rows_examined: 767                                 <br />SELECT COUNT(*) AS posts, SUM(B_Topic) AS topics.                                                   <br />                                        FROM   w3t_Posts.                                           <br />                                        WHERE  B_Posted > ''.                                       <br />                                        AND B_Approved = 'yes'.                                     <br />                                        AND    B_Board = 'forum';     <br /><br /># Query_time: 240  Lock_time: 205  Rows_sent: 1  Rows_examined: 767                                 <br />SELECT COUNT(*) AS posts, SUM(B_Topic) AS topics.                                                   <br />                                        FROM   w3t_Posts.                                           <br />                                        WHERE  B_Posted > ''.                                       <br />                                        AND B_Approved = 'yes'.                                     <br />                                        AND    B_Board = 'forum';    <br />