MySQL Forums :: Optimizer & Parser :: Very Large Non-Dynamic Table for Lookups


Advanced Search

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


Subject Views Written By Posted
Very Large Non-Dynamic Table for Lookups 3142 Eidetic Hans 10/23/2009 05:46PM
Re: Very Large Non-Dynamic Table for Lookups 1701 Rick James 10/24/2009 08:02PM
Re: Very Large Non-Dynamic Table for Lookups 1703 Eidetic Hans 10/24/2009 08:55PM
Re: Very Large Non-Dynamic Table for Lookups 1783 Rick James 10/24/2009 10:50PM
Re: Very Large Non-Dynamic Table for Lookups 1730 Eidetic Hans 10/25/2009 11:23AM
Re: Very Large Non-Dynamic Table for Lookups 1735 Rick James 10/25/2009 12:32PM
Re: Very Large Non-Dynamic Table for Lookups 1938 Eidetic Hans 10/26/2009 12:19PM
Re: Very Large Non-Dynamic Table for Lookups 1940 Rick James 10/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.