Number of Connections to a Access DB
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=22043
Printed Date: 29 March 2026 at 6:28pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Number of Connections to a Access DB
Posted By: webpromo
Subject: Number of Connections to a Access DB
Date Posted: 27 November 2006 at 6:52pm
|
Assume I have a database file (database.mdb) with 10 tables in it. It is better to have 1 DB file with 10 tables or 10 databases with 1 table?
I would think it's better to have 10 databases cause then you can have more connections avialable.
It the rule 10 concurrent connections per database (File) or 10 concurrent per table in a database file?
|
Replies:
Posted By: michael
Date Posted: 27 November 2006 at 8:18pm
|
Having 10 databases would mean you had to load the jet engine overhead for 10 databases which would result in a higher memory consumption. Plus you could not setup any relationships between the tables... unless you have a well visited site (and you should move to mySQL or MSSQL anyway) you are fine with your 10 tables. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: dpyers
Date Posted: 28 November 2006 at 12:08am
|
There's a concurrent connection limit for both the data base and the server. Opening 10 db's will probably get you a sarcastic email from the server admin.
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: MadDog
Date Posted: 28 November 2006 at 3:55am
|
10 databases would be worse than a one 100MB Access DB.
------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: WebWiz-Bruce
Date Posted: 28 November 2006 at 9:08am
|
IIS has a connection pool of about 20 for all Access databases on the server. This would mean that having 10 databases is worse than 1 in this instance as it would mean having to open 10 database connections instead of just 1. It would also be a big performance drain and you would see slower page processing times.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |