| Author |
 Topic Search  Topic Options
|
VBHS1999 
Newbie
Joined: 17 June 2003
Location: United States
Status: Offline
Points: 24
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum Capacity
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
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
VBHS1999
Newbie
Joined: 17 June 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
VBHS1999
Newbie
Joined: 17 June 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
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
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Pixel
Newbie
Joined: 26 August 2003
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
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! 
|
|
God_Struth
Senior Member
Joined: 07 August 2003
Location: United Kingdom
Status: Offline
Points: 218
|
Post Options
Thanks(0)
Quote Reply
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!
|
|
