Very Large Non-Dynamic Table for Lookups
I have a very simple table: Field A, Field B
No more data will be written to the table, only lookups are needed. The Table will consist of at least 500 million records but could possibly hit around 1 billion.
What would be the most efficient method in MySQL for performing these lookups? Multiple tables? One large table? Indexing strategies?
Field A would be unique.
This is mostly a theoretical question. But I do have some similar tables that are around 10 million records and we may be adding more soon (they're mostly for lookups, by the way).
Subject
Views
Written By
Posted
Very Large Non-Dynamic Table for Lookups
3879
October 23, 2009 05:46PM
1910
October 24, 2009 08:02PM
1978
October 24, 2009 08:55PM
2078
October 24, 2009 10:50PM
1984
October 25, 2009 11:23AM
2092
October 25, 2009 12:32PM
2130
October 26, 2009 12:19PM
2206
October 26, 2009 08:03PM
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.