Forum Capacity
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=3724
Printed Date: 02 April 2026 at 9:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Forum Capacity
Posted By: VBHS1999
Subject: Forum Capacity
Date Posted: 21 June 2003 at 4:40pm
|
Hello, Can someone tell me what capacities the access and sql versions have (related to total users and posting frequency)? In addition, what signs should I look for that my server needs to be upgraded to SQL? My server is running the following: Windows Server 2003 IIS 6.0 Dual 1 GHz Pentium III 1.75 GB RAM 120 GB 7200 RPM HDD Thanks, Kevin Carter |
Replies:
Posted By: michael
Date Posted: 21 June 2003 at 6:14pm
|
It is somewhat hard to tell when to change to SQL. You will notice at some point the database needs a compact more often and the performance just goes down. If you have that server dedicated for your site and not sharing it with others you should be good for a while but then as a shared server the memory might not be enough for huge access databases. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: VBHS1999
Date Posted: 21 June 2003 at 6:25pm
|
The server hosts one website, this site includes the forum. How large can I expect the access database to get? What signs mean I need to compact the database? Is there any way I can test the server to see how it is goignt o do? Kevin |
Posted By: ljamal
Date Posted: 22 June 2003 at 9:55am
|
If you have access to SQL Server, then rather than waiting until you need, you should just use it. Access is not really designed to handle applications like message boards. It does a fine job when used, but ultimately you should seek a more robust database. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: VBHS1999
Date Posted: 22 June 2003 at 9:16pm
|
I have MS SQL Server 2000 Enterprise. It is running on the server, but I have no clue how to set it up. I did what it said, but it won't let me get past the login page that will create all the necessary stuff in the SQL database. I read the guide, but I don't understand. I don't know if I am doing it right. Can anyone give me detailed instructions on how to configure WWF> How can I test if the SQL server is working correctly? Kevin |
Posted By: michael
Date Posted: 23 June 2003 at 8:46am
|
If you installed all the default options of SQL Server then it installs in Windows Authentication Mode. Go into the Server Properties with Enterprise Manager and change it to Mixed Mode. If you do a search on this forum I posted a pic a short while ago (DB Forum) where to find it. I am sure that this is the reson. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Pixel
Date Posted: 28 August 2003 at 3:04pm
|
I know some of you guys have a large user base with WWF. I'm planning on rolling out a site that could get quite large with W2K/2003 and an SQL 2000 backend. What is your user base? On what hardware? With what kind of response times? Thanks! |
Posted By: God_Struth
Date Posted: 28 August 2003 at 3:43pm
|
The access database version of the WWF Forum is well made and very robust in use, you can have a reasonably busy forum using the access version without any problems.
But... If you already have access to a SQL server database then by all means go with it, you will get better performance from the start for your forum. [VBHS1999] To configure a user to allow you sql access do this: Open enterprise manager and expand the security, then click on Logins to highlight it. Right click in the right pane and select new login. Give that login a username and password (whch you will use to create the forum) and give it Admin rights on the server. Click on databases and on the right pane right click and select New Database(just accept the defaults for the database). Next in the database you just ceated, add a login for the user you just created in the previous step. Then: Go into the forum folder and change the files common.asp to point to the database you just created also using the username and password just created on the sql server. Open the file mssql_server_setup.asp in your browser and enter the username and password for the sql server. That should enable you to run a version on your comp. Any more help needed give us a shout! |