MySQL Forums
Forum List  »  Optimizer & Parser

Very Large Non-Dynamic Table for Lookups
Posted by: Eidetic Hans
Date: October 23, 2009 05:46PM

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).

Options: ReplyQuote

Written By
Very Large Non-Dynamic Table for Lookups
October 23, 2009 05:46PM

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.