I have a simple mysql query that only involves one table - it runs too slowly and I'd like to know how to speed it up. here's the query select * from shows where ( lat BETWEEN '39.364477419355' and '41.945122580645' ) and ( lon BETWEEN '-75.239222580645' and '-72.658577419355' ) and ( whenint BETWEEN '1257532285' and '1267900285') order by whenint asc limit 300 EXPLAIN shows it doing a Simple select and using an index "using Where, using Filesort" When I do Show Processlist I...