Re: Extremely large tables
Posted by:
Rick James
Date: April 28, 2009 11:01PM
15GB won't be the problem. 15TB is getting huge.
The limits on columns is something like
* Columns per table (MyISAM): 4K.
* Columns per table (InnoDB): 1000.
However... The schema definition file is limited to 64KB. So, keep the column names short, and avoid ENUMS with a lot of options.
I suggest you consider vertically partitioning the data so that you don't have that many columns per table.
What kind of queries will you be doing with the data? Then, even 15GB could be cumbersome. Then, "clustering" of the data becomes important.
Subject
Views
Written By
Posted
4180
April 27, 2009 09:30PM
Re: Extremely large tables
2324
April 28, 2009 11:01PM
2475
May 01, 2009 01:28PM
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.