Posted 27 December 2005 - 08:17 AM
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?
Posted 27 December 2005 - 03:08 PM
Posted 27 December 2005 - 06:22 PM
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?
Posted 27 December 2005 - 08:39 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users