MySQL Forums
Forum List  »  Memory Storage Engine

How to load whole table in memory?
Posted by: Jack Ling
Date: April 18, 2005 03:22AM


I'm using mysql 5 on Fedora core 3.

Main aim to have a database for reporting purpose w/ a few larger tables. I guess to improve performance I can put the data of these tables into memory of the server. The tables are meant for read-only access. How can I do this? I already have the table in the default format. Is it what the HEAP table for? I need to do some conversion every time and then to upload to a HEAP table?

best regards,
Jack Ling

Options: ReplyQuote

Written By
How to load whole table in memory?
April 18, 2005 03:22AM

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.