Hi,
If my calculations are correct, your table will grow quite a lot
if you change from the MyISAM format to HEAP. The space to hold
the data will be roughly 1.3GB (a double of what it's with MyISAM!)
and the index will be another 1.3GB. Pretty huge, isn't it?
I think the dynamic row format is
Richard
Thanks for the info! I have just one more question. To get the structure of
the table I did a myisamchk and did a desc on the table. The output is shown
below. From this is it possible to determine the amount of RAM I would need
for a HEAP table?
Thanks!
MichaelT
MyISAM file: d
>Hi all
>
>I have a large table (20 million records) that I want to load into RAM to
>improve selects. I understand (from previous posts) that I must create a
>HEAP table. Please correct me if I'm wrong on this. My question is - how
>much RAM do I need if the MYI and MYD files are as follows :-
>