Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performance : split in two db or stick with one

Status
Not open for further replies.

JFRobishow

Technical User
Jun 18, 2003
87
CA
Hi,

I have a rather large collection of pictures that I want to display in galleries on a website. All the pictures are divided in two major categories.

Right now it's querying an Access 2002 database for the path, size, type, etc. Would it be better performance wise to split the collections of pictures in two databases (one for each major category) containing fewer tables each, or is it just as good to have one database containing many tables.

The total database size is less than 3MB and there's not many users on the site at the same time so the limits of 255 concurrent users is not a problem.

Thanks in advance for advices.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top