Access 2002, ASP Perfomance question 1

[JFRobishow]

Hi,

I'm building a database driven web gallery for a webpage (using access 2002 and ASP). There are about 3000+ pictures that I added in a database. I then query the database for the path, type, etc. The pictures are divided in two major categories and then those two are divided in smaller sub categories (the gallery). I'm wondering what would be better perfomance wise.

Should I use two seperate database for each major categories or is it the same to use only one that contain the table for both categories since it will only query one table at a time anyway.

Right now I'm thinking that one database will work just as well as two database. The only reason I see why I should use two is if there's a lot of traffic in which case it would be useful to divide the load between two databases but that isn't the case, the limit of 255 concurrent users is enough.

Since I'm not that experienced I thought I would ask here to make sure. Thanks in advance! I appreciate it.

 

[onpnt]

two databases would create a performance issue. you need multiple connections and such at that point. using the paths in the DB only as you are is the best way to optimize the performance with images. 3000+ record to maintain is not that much and would be fine for a desktop database such as access

unless you're loading every picture at the same time the traffic shouldn't be a concern. If it does the next thing to do is upgrade to a database that is designed to be hit like that. such as SQL Server or MySQL

_____________________________________________________________________

_{Hakuna matata!!}

 

[JFRobishow]

Thank you for the quick reply.

 

[SatishPutcha]

As an aside, I would also add that always make sure that you close all your connections. I have already cleaned up two websites that stopped functioning since they had connections open galore.

Otherwise, yes, one DB should do quite well.

Regards
Satish