How much load WebWiz on MS Access handle?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16784
Printed Date: 16 April 2026 at 3:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How much load WebWiz on MS Access handle?
Posted By: arunv
Subject: How much load WebWiz on MS Access handle?
Date Posted: 03 October 2005 at 7:50am
Iam trying to deploy an ms acces - webwiz setup. Since iam already
going to use our member database of 2000+ members, our team suspect
perfomance of the forum.
Please let me know how sdo you feel Anybody using ms access with big user base?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 03 October 2005 at 8:43am
MS Access has allot of limitations and although I have seen web wiz
forums with over 8,000 members and 50,000 posts running on Access it
depends very much on the environment it is running in.
Connecting to Access databases from an ASP page usually uses the ADO
pool, on most servers this is limited to 20 shared between all sites on
the server, so can course problems on busy servers using allot of
databases.
Other problems with Access is that because it is a flat file it tends
to get large very quick and requires the whole flat file to be loaded
into the servers memory every time it is accessed.
I often find that on busy sites because Access was designed as a
desktop database it can not cope with the demands placed on it by a
forum 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.
-------------
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
|
|