MySQL Forums
Forum List  »  Performance

Best setup for this table?
Posted by: David Robinson
Date: February 01, 2005 06:01AM

I have a client with a requirement to build a rather large table. My initial thoughts are concerned with performance so I thought I'd ask the experts!

Each record will hold around 40 fields. 32 of these are for specific data types and can hold around 100 different numbers (though the list is constantly growing). Let's say the fields are A1 to H2 (32 fields).

Searches are done by relating one record to another, by the specific data types. A positive match would be one that matches a minimum of 20 fields (fixed variable in case it needs to be changed).

The way I see it, it's going to run 32 queries against each record (could eventually be millions of records) so it soon gets to be a very fat query.

So how do places like Google do it? Surely this is a similar DB query? Should I rethink the DB structure, or the way I store the specific data?

Thanks,

David

Options: ReplyQuote


Subject
Views
Written By
Posted
Best setup for this table?
2221
February 01, 2005 06:01AM
1587
February 09, 2005 12:52AM
1588
February 11, 2005 09:55AM


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.