ARCHIVE table very slow...
Hi
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?
Subject
Views
Written By
Posted
ARCHIVE table very slow...
12144
January 21, 2009 08:22AM
6235
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.