| Author |
 Topic Search  Topic Options
|
rob_andy 
Newbie
Joined: 21 February 2003
Location: United Kingdom
Status: Offline
Points: 33
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Post Message Errors
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
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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 -->
Edited by dj air - 18 February 2005 at 4:28pm
|
|
rob_andy
Newbie
Joined: 21 February 2003
Location: United Kingdom
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 February 2005 at 4:31pm |
|
Is it easy to migrate from the access to the SQL?
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
rob_andy
Newbie
Joined: 21 February 2003
Location: United Kingdom
Status: Offline
Points: 33
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by -boRg- - 23 February 2005 at 9:28am
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
