Re: About performance for Database of millions of records
If InnoDB, set innodb_buffer_pool_size to about 70% of RAM.
If MyISAM, set key_buffer_size to maybe 1/3 of RAM (depends on relative size of index files (.MYI) and data files (.MYD).
Can't go any further without knowing what kinds of queries you do. Also please SHOW CREATE TABLE.
What do you mean by "tuple"? RDF? If so, back off! One table row per tuple is grossly innefficient. Use Property tables. Toss tuples that you aren't using for searching into blobs that your application parses. Etc.
In some situations, a million rows is no problem; in others it is a nightmare.
Subject
Views
Written By
Posted
7325
April 09, 2008 02:07PM
2824
May 07, 2008 09:04AM
2602
May 07, 2008 02:56PM
2606
May 07, 2008 07:29PM
2715
May 07, 2008 09:36PM
2957
May 24, 2008 10:16AM
Re: About performance for Database of millions of records
2067
May 27, 2008 11:29PM
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.