Afternoon All,
The table is read only for most of the day and will get updated (once I get the queries down to an acceptable level) nightly...if that helps.
Any suggestions or further tips would be very helpful as its taken me months to get my code to input the data in the way I need its now trying to get the data back out that is the problem.
Thanks John
John,
Create a second table (MyISAM) but this time don't use compression on the table.
create table newtable select * from oldtable;
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.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
