Jump to content

Archived

This topic is now archived and is closed to further replies.

renwoshin

Efficiency Question

Recommended Posts

Hi --

 

I wonder what is more efficient and returns a quicker response for the server: One table with 3000 values, or 30 tables with 100 values each?

 

Thanks

Share this post


Link to post
Share on other sites

Querying one table is definitely faster than querying 30 tables! By "values" do you mean columns? If so, you probably should be breaking up groups of related fields into different tables to keep with normal-form recommendations for RDBMS table design. Please clarify.

Share this post


Link to post
Share on other sites

[!--quoteo(post=330652:date=Dec 27 2005, 07:08 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Dec 27 2005, 07:08 AM) 330652[/snapback][/div][div class=\'quotemain\'][!--quotec--]

Querying one table is definitely faster than querying 30 tables! By "values" do you mean columns? If so, you probably should be breaking up groups of related fields into different tables to keep with normal-form recommendations for RDBMS table design. Please clarify.

 

Oh, by values i mean by rows. There will only be about 7 columns. Every table will have these same columns. So instead I should have a massive table as opposed to separate ones?

Share this post


Link to post
Share on other sites

First, 3000 rows isn't a lot. Second, since the "logical" option would be to group all of them into a single flag with a type flag, what's the basis for keeping them separate? That is, how does this help?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.