|
 |
asp_databases thread: How many users at a time access accepts
Message #1 by "Ivan" <ivanv@w...> on Thu, 22 Mar 2001 09:42:43
|
|
can someone tell me how many users at a time Ms Access accepts. I have
heard 255 but in reality is this real, or at-least in ASP.
Is ms Fox-Pro better than access for web development?
Thanks
Message #2 by Scott Watermasysk <swatermasysk@C...> on Thu, 22 Mar 2001 08:43:22 -0500
|
|
In reality it is not real. It is more likely access can support about 64
connections, but performance is known to start to deteriorate at around 30
or so users.
Keep in mind this is concurrent users. So for performance to dwindle you
would need 30 or more users to be running a query against your database at
the same exact time. You could have 300 people at your site, but chances are
30 or more would not be hitting your db at the same time.
Access has problems because it is a single-threaded-apartment. There is a
good article comparing Access to SQL Server on Charles Carroll's
www.learnasp.com site. The article can be found at:
http://www.learnasp.com/learn/accessSQLserver.asp
At the bottom of the article there is a script that will show you how many
concurrent connections your access db can support. It usually starts to
create errors at about 64 connections.
Hope this helps.
Scott
-----Original Message-----
From: Ivan [mailto:ivanv@w...]
Sent: Thursday, March 22, 2001 1:14 PM
To: ASP Databases
Subject: [asp_databases] How many users at a time access accepts
can someone tell me how many users at a time Ms Access accepts. I have
heard 255 but in reality is this real, or at-least in ASP.
Is ms Fox-Pro better than access for web development?
Thanks
Message #3 by "Tomm Matthis" <matthis@b...> on Thu, 22 Mar 2001 09:39:29 -0500
|
|
If you using Access as the back-end for you website... 10 (and maybe 20)
is about the max... performance REALLY suffers when you get up around 10
and goes downhill from there...
I believe FoxPro has a bit higher limit, but if you gonna have serious
traffic to the site, IMHO, then go for SQL (in whatever flavor you
prefer ... Oracle, mySQL, etc.)
Tomm
> -----Original Message-----
> From: Ivan [mailto:ivanv@w...]
> Sent: Thursday, March 22, 2001 1:14 PM
> To: ASP Databases
> Subject: [asp_databases] How many users at a time access accepts
>
>
> can someone tell me how many users at a time Ms Access accepts. I
have
> heard 255 but in reality is this real, or at-least in ASP.
>
> Is ms Fox-Pro better than access for web development?
>
> Thanks
>
>
>
|
|
|
View Cart
