https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 23:41:11 +0000 Mon, 03 Oct 2005 08:43:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16784 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/how-much-load-webwiz-on-ms-access-handle_topic16784_post91599.html#91599 Author: WebWiz-Bruce
Subject: 16784
Posted: 03 October 2005 at 8:43am

MS Access has allot of limitations and although I have seen web wizforums with over 8,000 members and 50,000 posts running on Access itdepends very much on the environment it is running in.

Connecting to Access databases from an ASP page usually uses the ADOpool, on most servers this is limited to 20 shared between all sites onthe server, so can course problems on busy servers using allot ofdatabases.

Other problems with Access is that because it is a flat file it tendsto get large very quick and requires the whole flat file to be loadedinto the servers memory every time it is accessed.

I often find that on busy sites because Access was designed as adesktop database it can not cope with the demands placed on it by aforum and often becomes corrupted and data can be lost.

I always recommend that unless you have a handful of users to use the MS SQL Server version.
]]> Mon, 03 Oct 2005 08:43:56 +0000 https://forums.webwiz.net/how-much-load-webwiz-on-ms-access-handle_topic16784_post91599.html#91599 https://forums.webwiz.net/how-much-load-webwiz-on-ms-access-handle_topic16784_post91592.html#91592 Author: arunv
Subject: 16784
Posted: 03 October 2005 at 7:50am

Iam trying to deploy an ms acces - webwiz setup. Since iam alreadygoing to use our member database of 2000+ members, our team suspectperfomance of the forum.

Please let me know how sdo you feel  Anybody using ms access with big user base?
]]> Mon, 03 Oct 2005 07:50:15 +0000 https://forums.webwiz.net/how-much-load-webwiz-on-ms-access-handle_topic16784_post91592.html#91592