Web Wiz Forums - Post Message Errors

Print Page | Close Window

Post Message Errors

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=13889
Printed Date: 12 April 2026 at 6:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Post Message Errors

Posted By: rob_andy
Subject: Post Message Errors
Date Posted: 18 February 2005 at 4:20pm

Hi there, my site has been running webwiz forum for a few years now and its been great. Recently we have got a lot more users and we're now upto 700 members. We get a lot of reports from people saying they get problems posting messages during busy times. Is there a maximum number of active users on the access version of webwiz? Does anybody else experience these problems? Basically when you try and post a message is takes ages. When I've looked through the log files it also show post_message.asp as the top page that errors. Thanks in advance. Rob

Replies:

Posted By: dj air
Date Posted: 18 February 2005 at 4:24pm

this is because you are using an access version with the activity it sounds like your site gets..

you should concider the SQL version. as it can cope with more connections and runs better all together.

<-- edit-->
Please do not double post
<--/edit -->

Posted By: rob_andy
Date Posted: 20 February 2005 at 4:31pm

Is it easy to migrate from the access to the SQL?

Posted By: dj air
Date Posted: 20 February 2005 at 5:20pm

this depends on your knowlege.

there is a topic on doing this pinned to the top of this forum..

Posted By: rob_andy
Date Posted: 23 February 2005 at 8:37am

Out of interest does anybody have any idea about how many concurrent users the access version of the forum can support? and how does this compare to the SQL version. It seems whenever the active users is above 5 its almost impossible to post a message cleanly. When you click post message its takes approx 2 minutes before it timesout. Then you have to close all your ie windows before going back on. Then the message has been posted. Has anybody ever come across this?

Posted By: WebWiz-Bruce
Date Posted: 23 February 2005 at 9:21am

It's not so much how many concurrent users web wiz forums can support, but more to do with the server.

Access as a database can only cope with 225 concurrent users, however, this is made worse on a web server.

Most web servers have a connection pool of 20 for access databases, this means that only 20 concurrent users at one time across the entire server.

That's 20 concurrent users for ALL web sites and ALL Access databases stored on that server, not just your site!!

MS SQL Server doesn't have this limitation on the Enterprises version and can have almost an unlimited number of users connecting.

Access as a flat file system also suffers from performance issues, size issues, and often easily becomes corrupted.

MS SQL Server is far more robust which is why large organisations such as banks use it.

Access costs around �200 as part of office to buy and MS SQL Server costs around �19,000 for the Enterprise version. The cost alone says it all.

-------------
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

Posted By: WebWiz-Bruce
Date Posted: 23 February 2005 at 9:24am

Also I forget to mention, delays as long as you mention in posting messages are usually a result of your SMTP server.

If email features are enabled when you post a message email notifications need to be sent, if the SMTP server takes time to connect to, or is overloaded, this often courses the long delay you mention.

If you can use CDONTS as it will use a 'localhost' SMTP server so you won't have this delay.

To test this out if email is the problem, disable email notifications from the admin area and see if posting times are improved.

-------------
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