MySQL Forums
Forum List  »  Archive Storage Engine

ARCHIVE table very slow...
Posted by: Marcin Piatek
Date: January 21, 2009 08:22AM

I'm testing the ARCHIVE storage engine and i vase some performance problems...

Test table consist of 30 columns:
- 1 blob,
- 1 bigint (primary index),
- 24 int,
- 1 datetime,
- 3 float.

Currently I've got 13000000 records inside, they use 13GB on MyISAM and only 3GB on ARCHIVE.

When i was testing random selects from this table I've got results on selecting 1 row:
MyISAM : 25ms average
ARCHIVE: 47615ms average.

Am I doing something wrong or does ARCHIVE cannot search for given KEY and must read whole table?

Options: ReplyQuote

Written By
ARCHIVE table very slow...
January 21, 2009 08:22AM
January 21, 2009 03:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.