PDA

View Full Version : Database vs table efficiency



ketanco
22 Apr 2008, 06:44 PM
Let me ask this way:

As far as the following considerations below, which option is better:

A) One database with many tables B) About 10 databases with very few tables

Compare for each criteria below please:

Searching data
Retrieving and displaying data
Backup
Updating
Security
Future expansions (as far as columns or tables)

Can you please compare option A and B for each of these criteria?

Thanks