On Thu, 2004-11-11 at 15:51, mos wrote: > John, > Create a second table (MyISAM) but this time don't use compression > on the table. > > create table newtable select * from oldtable; >
Right will run that just now, good idea...just have to avoid the wife as no doubt it will bog the site down and she has a production site on the same server ;-) > Create the compound index as someone else had suggested using Alter Table. > > Repeat the query and it should return 9000 rows in a couple of seconds. We > have tables with tens of millions of rows in them and doing an index > retrieval on a few thousand rows is very fast. The problem is either the > compression or index. Will report back on success etc Cheers John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
