Need Help With Table Performance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

This might seem like a stupid question, but I thought it might affect the
performance of the database.

Im designing my tables at the moment for a stock control system.
Will the db perform quicker if I have fewer tables, but with more data in.
Or have more tables, with fewer data?
Will this matter or does it depend on indexing? If it does, which should I
use?

Thanks for all your help,
Louisa Holt
 
Louisa

The number of tables is moot (or largely unimportant until you get to very
large numbers of tables).

The trick with a relational database (e.g., Access) is designing
well-normalized tables. If you try to replicate a spreadsheet in an Access
table, Access won't be able to efficiently use its features and functions,
and you will be constantly developing work-arounds.

If "normalized" is an unfamiliar term, check Jeff Conrad's website:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top