Hosting problems. Help!
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=12883
Printed Date: 12 April 2026 at 12:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Hosting problems. Help!
Posted By: Alfa
Subject: Hosting problems. Help!
Date Posted: 07 December 2004 at 5:50pm
| I have a lot of problems with the speed of the forum. I have upgraded from version 6.3 to 7.9 in order to fix this problem. But it still exists. After all my promotion of the site I am loosing members rapidly. I now believe it to be caused by the server it is installed on. The hosting service says the problems occur because of bad programming & sql statements and therefore amounts of members would be to heavy on their server. But since the slowness/server errors do occur not only when there are many members, but also when there are few members I do not believe that and think something is wrong with the server. I would like to show the hosting service that there are other forums which succesfully have large amounts of members. Could you please post a few links to such webwiz forums with many members? I could use this against their arguments. I really need to fix this problem. |
Replies:
Posted By: dj air
Date Posted: 07 December 2004 at 6:31pm
|
how many members do you have and im not sure from what you say, what version are you on (DB). also how many hits a day do you get on average. also how big is the database. we can tell from that if its likely ot be overloading the server. |
Posted By: WebWiz-Bruce
Date Posted: 08 December 2004 at 4:06am
|
The problem isn't bad programming as the programming in the forum is very tight. The problem often comes from using Access as your database backend. Access as a flat file database system uses allot of the web servers resources which slow down the entire server. Access works OK with forum software if you have a small forum with only a handful of members, but if your forum is large or has allot of members that use the forum it will really push the server as each time a page in the forum is called the entire Access flat file needs to be loaded into memory also using up connections from the limited Access database pool available to all sites on the server. If your forum is at all large or popular you should consider using the MS SQL Server version as SQL Server not being a flat file system and also usually having the SQL Server located on dedicated server, is much better at handling things like forum software. If you want performance you should upgrade to MS SQL Server. ------------- 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: 08 December 2004 at 4:09am
|
If your host charge allot of money for MS SQL Server, you should
checkout our own hosting we offer windows hosting with MS
SQL Server support for only $6.99 per month. We have also helped allot of poeple who use Web Wiz Forums access version to move across to MS SQL Server on their hosting accounts. http://www.webwiz.net/webhosting" rel="nofollow - www.webwiz.net/webhosting ------------- 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: xeerex
Date Posted: 08 December 2004 at 8:37am
|
While you should certainly consider moving to MS SQL Server for a large
forum, I can attest that WWG will certainly handle a load even under
Access. Here are the stats of my largest forum: We have 14040 Forum Members Avg New Members per day: 45.72 (excluding today) New Members today (so far): 3 | Yesterday: 23 # of Members Visiting Site Today: 107 (excluding new members) We have 4163 Posts in 744 Topics in 21 Forum(s) *Note: I have purged the database twice removing approx 4k members each time who had no posts in 30 days. Current database size is 14MB. At peak times, my active users list will show 80-160 members, although normally it cruises along between 20-40. This is the key with Access, concurrent connections. It does not handle lots of connections as MS SQL Server can; however, if the server is setup properly and you maintain the database, Access can do ok up to a point. Yes, I am on a shared server as well. My host has to restart the server about once a week, but that is fairly typical on a shared MS server and was happening before I started that forum anyway. I hope this information helps. In summary, yes WWG will definitely scale. It naturally performs very well under MS SQL Server, but also performs very respectably under Access. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: Alfa
Date Posted: 09 December 2004 at 4:43pm
|
I'm on ms sql server. Webwizforum 7.9 I have 32648 Posts in 5093 Topics in 47 Forum(s) The database is around 100 mb. 2731 members. (I purge the database for inactive members weekly) I get 1337 page views per day. Most of the time there are 10-40 active users. Every time I do something to promote my site or bots come by, the amount of visitors goes up and that's the end of the forum, because I get server errors and pages won't load or load extremely slow. The slowness of the forum is not only there when I get lots of visitors, but also at various other times.
Xeerex, that helps a bit. Can anyone point me to a webwiz forum site which has over 200 active members regularily?
|
Posted By: Alfa
Date Posted: 17 December 2004 at 8:37pm
| Anyone? I was getting about 100 new members a day until the server errors started to chase them off. I now get around 1500 pageviews a day. |
Posted By: WebWiz-Bruce
Date Posted: 18 December 2004 at 5:11am
|
You haven't mentioned what the errors are so can not really help. If you are finding it's running slow and you are having over 200 concurrent uses then you are probably using allot of server resources as that is allot of database hits, page views, and data transfers. With that amount maybe you need to look for a web host with less populated servers, or even a dedicated server to cope with the amount of resources your forum requires. On a shared hosting environment your host has probably limited the resources your site has available so that when your site comes under allot of load it doesn't effect other sites on the servers, therefore your site will run low of resources and run slowly. ------------- 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: 18 December 2004 at 5:18am
|
Also you mention that your MS SQL Server is at 100Mb, which seems like
allot for 32648 Posts in 5093 Topics and
2731 members, as this site has at least twice that as well as the
database being used for other things and the size is still under 65Mb. Check that the recovery model for your SQL Server database is on 'simple' this should speed things up with the MS SQL Server and cut the size down on the transaction log. Also 47 forums is a hell of a lot and this will course problems, you should try cutting down the number of forums you have. ------------- 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: Alfa
Date Posted: 07 January 2005 at 2:49pm
|
My site is about 100 mb, the database is less.
This is one of the errors I am getting:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /forum/default.asp, line 314 |
Posted By: dj air
Date Posted: 07 January 2005 at 2:51pm
| make sure the connection settings are correct in the server_connection.asp file in the admin folder. |
Posted By: dj air
Date Posted: 07 January 2005 at 2:55pm
ive just read the rest of the thread how often does this happen. or is it always. that error, if its once and a while the server may have to have been restarted. etc |
Posted By: Alfa
Date Posted: 08 January 2005 at 7:54pm
|
Here are two more:
---------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /forum/includes/pm_check_inc.asp, line 67 --------------------------------------------- ----------------------------------------- Microsoft OLE DB Provider for SQL Server error '80004005' Timeout expired /forum/default.asp, line 314 ----------------------------------------- Further we are getting a lot of "acces denied" or "page does not exist" The errors occur frequently, but without real pattern. Only thing I can say is most in the weekend and when there are 40+ users on the forum at the same time.
|
Posted By: WebWiz-Bruce
Date Posted: 09 January 2005 at 6:36am
|
These are all server issues that you need to take up with your web host. The 'SQL Server does not exist or access denied' error usually happens if for whatever reason the SQL server can not be connected to. It occasionally happens on this site and is often coursed by things like network problems connecting to the SQL Server, the SQL Server could be rebooting, or even over loaded. The 'SQL Server error '80004005' Timeout expired' error is very similar to the one above and is often coursed when the SQL Server doesn't return data within the server specified timeout limit. This again is a sign of network problems or an overloaded SQL Server. With the amount of server related issues you are getting I think it's time you started looking for a new host. You could try our own hosting, at http://www.webwiz.net/webhosting" rel="nofollow - www.webwiz.net/webhosting ------------- 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: Alfa
Date Posted: 16 January 2005 at 7:10pm
| Does anyone have tips for a good host in the Netherlands? |
Posted By: Phat
Date Posted: 16 January 2005 at 10:24pm
| Does it make any diff were your host is? I have a few hosts located around the world. |