MySQL Forums
Forum List  »  Memory Storage Engine

Re: How to load whole table in memory?
Posted by: Ingo Strüwing
Date: May 06, 2005 07:12AM

Right, but anyway you can try out if it helps in your application. A possible way to start experimenting with is CREATE TABLE new_table ENGINE=MEMORY AS SELECT * FROM old_table; If this improves the performance for you, you can modify the select statement for your needs.

Options: ReplyQuote


Subject
Views
Written By
Posted
19780
April 18, 2005 03:22AM
Re: How to load whole table in memory?
10568
May 06, 2005 07:12AM


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.