Database Discussion - One dtatabase or more per site

Print Page | Close Window

One dtatabase or more per site

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8159
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: One dtatabase or more per site

Posted By: solgel
Subject: One dtatabase or more per site
Date Posted: 17 December 2003 at 8:21am

I know that using access is limiting the number of simultaneous connections you can support on your server. So my question is it is better to have many databases (many files one for each application) or put all tables on the same database (one file)?

Thanks in advance for the clarifications

Replies:

Posted By: zaboss
Date Posted: 17 December 2003 at 9:54am

Well, there isn't only one answer for this questions. For me putting all the tables in 1 db was better. Now it has about 10 MB and growing, and I did not notice any problems in speed or so. I have there maximum 200 vistors/day. I have had an Access DB of 46 MB, but the site wasn't much visited (less then 50) so I don't know if could handle a serious trafic.

Is not much the db that realy counts, but the code. If the code is lowsy chances that the db would crush grow accordingly. If you plan to have a heavy trafic site, you'd better consider MS SQL or MySQL. They are much better equiped for web usage.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web