MySQL Forums
Forum List  »  Archive Storage Engine

Archive Engine and Direct Access to Indices
Posted by: Andrew Vehlies
Date: June 25, 2012 12:03PM

Hi,
I'm part of a project that right now is using Archive tables to hold log data. We are finding an increasing need to access data from these tables, but read speeds can be very slow due to the scanning of the whole tables. I know there is an index on the AUTO_INCREMENT value (`contact_id` in this case). Since there is an index, wouldn't a WHERE `contact_id` = xx clause be a quick lookup? Does it still do a complete table scan even though it's searching on an indexed field?

I believe I read on the Wikipedia page for the Archive storage engine that there were plans to add more indeces onto the Archive-typed tables. Is there any update on this? Perhaps it's something I can add to the type if it's no longer being worked on.

Options: ReplyQuote


Subject
Views
Written By
Posted
Archive Engine and Direct Access to Indices
5240
June 25, 2012 12:03PM


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.