Can anyone recommend a better way to do this query?
This query executes about once an hour right now, we may run it more frequently in the future and the amount of rows in the table will continue to grow (currently at around 3mm +).
Query_time: 3.202836 Lock_time: 0.000091 Rows_sent: 1 Rows_examined: 3444018 Rows_affected: 0 Rows_read: 3444018
select count(*) from phplist_usermessage where date_add(entered,interval 3000 second) > now() and status = “sent”;