CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> General -> Web Design

 user

Print topic Send  topic

Author Message
lstamant
Posted: 10/06/2005, 6:25 AM

Is anyone using MS Access as a web db? If so, what's the maximum number of simultaneous users you are handling? In other words, how many users can Access gracefully support before we need to upsize to another db like SQL Server or MySQL?

Thanks for your opinion.
peterr


Posts: 5971
Posted: 10/06/2005, 10:48 AM

Based on http://msdn.microsoft.com/library/default.asp?url=/libr...l/msdeforvs.asp MS Access (JET) supports maximum of 255 users, but recommended for up to 20 total users.

Based on http://www.aspfaq.com/show.asp?id=2195 "Sorry to disappoint you, but there is no such magic number. There are far too many variables involved..."

Based on our own tests we could have 10 concurrent users couple years ago but haven't run into this limit after moving to a new Windows server. We still use MS Access on our support site at http://support.yessoftware.com , without problems.
However we occasionally archive parts of the database (move partial data into another database) because otherwise some SQL search queries take more and more time when the .mdb file grows.

Also keep in mind that you can have thousands of simultaneous users if they are not very active. It is rather the number of simultanous queries that may limit you, so when one user is running an SQL query then other users may wait until that query is finished before they see their Web pages. If each user is displaying just one record then probably the query will take only a split of a second and none of the users will have noticable delays.

See http://forums.codecharge.com/posts.php?post_id=44028 for a previous related discussion.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.