Single vs multiple databases

[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

 

[Net55]

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

 

[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

 

[novus]

Thank you bothe for the advice.

novus

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