<div>
<b>NEVER EVER USE <i>SELECT *</i></b> &nbsp;<b>ALWAYS USE <i>LIMIT</i></b><br />
<br />
But that said, there are some really good articles here at EE about MySQL performance. &nbsp;Example here:<br />
<a href="https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html" rel="ugc">https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html</a>
</div>


NEVER EVER USE SELECT *  ALWAYS USE LIMIT

But that said, there are some really good articles here at EE about MySQL performance.  Example here:
https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html [https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html]

<div>
<div class="content wysiwyg-content">
This is a very simple table with 6 columns. &nbsp;Currently the table has more than 4 million records. &nbsp;This is the query:<br />
<br />
<br />
<b>SELECT * FROM chamber_ghst <br />
WHERE chamberid='Ambient' and <br />
actiondate BETWEEN '2013/06/12 12:06:00' and '2013/06/13 12:06:00' <br />
ORDER BY actiondate ASC</b><br />
<br />
<br />
This query results in 288 records. &nbsp;It takes about 16 seconds. &nbsp;I just don't see why or understand how I can optimize this.
</div>
</div>


This is a very simple table with 6 columns.  Currently the table has more than 4 million records.  This is the query:


SELECT * FROM chamber_ghst 
WHERE chamberid='Ambient' and 
actiondate BETWEEN '2013/06/12 12:06:00' and '2013/06/13 12:06:00' 
ORDER BY actiondate ASC


This query results in 288 records.  It takes about 16 seconds.  I just don't see why or understand how I can optimize this.

Slow simple MySQL query (date range)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.