Single vs multiple databases

N

novus

I have a large website and am lokking at using Access databases to serve
information from a number of unrelated databases. Would I be better off
using one database with unrelated tables or a separate database for each set
of data?

novus
 
N

Net55

If the site gets a lot of traffic use multiple datbases,
if you have the means use more than 1 server.
 
M

Mark Fitzpatrick

Multiple databases is a good way to go when you have disparate information.
It helps the performance of the db since you're not bottlenecked going to
one database. It also helps the reliability since everything can't go down
if the database gets locked or has problems.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
 
N

novus

Thank you bothe for the advice.

novus

Mark Fitzpatrick said:
Multiple databases is a good way to go when you have disparate information.
It helps the performance of the db since you're not bottlenecked going to
one database. It also helps the reliability since everything can't go down
if the database gets locked or has problems.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
Click to expand...
 
Top