more tables or less tables

Moothursh

New member
Local time
Today, 04:25
Joined
Apr 14, 2013
Messages
5
i have been thinking whether to us more tables with less fields or less tables with more fields.
which one is efficient?


RSVP

Rgds,
Moothursh.:)
 
When telling a story, do you in advance decide to use long words in short sentences or short words in long sentences?
 
Please define efficient in your set up.
 
moothursh

it's not an optional consideration

use the correct number of tables and fields to achieve a normalised structure.

you cannot just decide to use fewer tables, with more fields in them, if that introduces redundancy.
 
First, I agree with the other posters that you want to use the right number of tables to correctly represent the data characteristics of your data set. Proper normalization will dictate the number of tables based on your business model (if it is a business) or your data behavior (if you are tracking something in nature) or whatever.

However, there is a different answer to consider. You have an absolute limit of 255 fields and 2048 total bytes per record in any one table, not counting large binary or text objects. (BLOBs and Memo fields). You want to avoid jam-cramming stuff into a few tables if your action brings you close to either of those limits. Whether your tables are of the "many but shallow" design or the "few but deep" design, you must consider that you will run into limits of one kind or another.

Here is a thought to add to your design issues. Often, you can design a bunch of tables in the "many but shallow" format and then, where appropriate for your situation, build queries that APPEAR to be "few but deep." Don't forget that tables and queries typically have one thing in common - they both produce recordsets usable in other queries, forms, reports, and VBA code that uses ADO or DAO operations on recordsets.
 
ayy The Doc Man, what a name, anyway this is really helping. especially when it comes to normalizing. ithink i have found the answer to my question, now lemme try and implement it and see the out come.

KUDOS!!!!!!
 

Users who are viewing this thread

Back
Top Bottom