Re: BIG DATABASES, 60 millions of rows!
Hi,
You should definitely take a look at partitionning. I saw MyISAM databases which are almost 100G with billions of row and still achieve very good performances. Indeed, the restriction for such big database is index size wich make you server slowed down by I/O wait.
You could reconsider your indexing scheme (a sorted table reduce index size, packed keys, ...) and try partitionning your 60 000 000 tables into smaller one you can address directly.
Regards,
Subject
Views
Written By
Posted
2252
March 28, 2006 08:19AM
Re: BIG DATABASES, 60 millions of rows!
1374
April 23, 2006 08:25PM
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.