How to load whole table in memory?
Posted by:
Jack Ling
Date: April 18, 2005 03:22AM
Hi,
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
Subject
Views
Written By
Posted
How to load whole table in memory?
19958
April 18, 2005 03:22AM
12377
April 20, 2005 10:40PM
10649
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.