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.