MySQL Forums
Forum List  »  Memory Storage Engine

Re: DELETE query slow on Memory storage engine
Posted by: KimSeong Loh
Date: July 16, 2007 05:53PM

You have an index on the timestamp column?

Memory engine uses Hash index by default, so that won't help your range search. You can recreate the index using btree on version 4.1 or above.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: DELETE query slow on Memory storage engine
9168
July 16, 2007 05:53PM


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.