MySQL Forums
Forum List  »  MyISAM

MyISAM - Static or MyISAM - Dynamic
Posted by: Peter Meier
Date: February 12, 2006 06:06AM

Hi guys

I'm setting up a new database (actually not a real database but only one large table). I expect about 1'000'000 rows in this table and I'm not sure wheter to choose MyISAM Static or Dynamic.
One entry (row) is about 1.1 KB in Static Mode, so the whole Table would be about 1.1 GB. In Dynamic mode one row is 450 B, the whole table in Dynamic mode would be about 450 MB...
I've read about the better security of Static tables in case of any crash, is these an argument for Static?
After writing the entries there will only be a few updates of the existing rows, mainly I plan to use select statements for extracting the data.
What do you think, static - dynamic? or does it not matter with this size of data?

thx
peter

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM - Static or MyISAM - Dynamic
4707
February 12, 2006 06:06AM
2231
February 12, 2006 11:31AM


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.