Re: ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-30 Thread Johan De Meersman
Correct. I assume the thinking behind it, is that you use that kind of table for huge amounts of inactive data, so it doesn't matter if your selects are a bit slower. Also, keep in mind that because it is a compressed file format, you will be scanning much more data per physical read than with a

ENGINE=ARCHIVE doesn't support INDEX!!??

2010-09-29 Thread Daevid Vincent
I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org