On Thu, 2004-11-11 at 14:36, Philippe Poelvoorde wrote: > Hi, > > could you try adding a key with > ALTER TABLE properties ADD INDEX(countyid,old,price); > It could maybe help getting less rows at a time.
I dropped the old and price for the where clause and the number of rows scanned were the same as without the limit which is good so I am guessing the 3 coloum index will do the same. Problem is that it still took 30+ seconds. To return 9000 rows. Not an acceptable performace really. Any other ideas? John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]