With the following query if I it returns 2 results it's fast .04s, if it has less results than the limit it takes 1minute.
Query: select * from hub_dailies_sp where active='1' and date='2010-08-04' order by id desc LIMIT 2; Show create table: http://pastebin.org/447171 27,000 rows in table/view Can anyone shed any light? Cheers, Kristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
