What database does the Snitz community forum run on? I have a client that wants to run on SQL Server 2000 and is interested in scalability. Are there any really big implementations out there that use SQL Server as the database?
We are using SQL Server 2000 on this site for this forum.
This forum has been tested on the following databases:
Microsoft Access 97/2000/2002 Microsoft SQL Server 6.x/7.x/2000 MySql (not sure what the earliest version was, but you should try to always use the latest stable version). (usually requires MyODBC to be installed as well)
One more question. The client uses two web servers behind a hardware load balancer. The load balancer won't tolerate session variables in its current configuration. Does Snitz use session variables?
Unless it was changed recently, session variables are used to keep the date last here too.
Also, I don't think Application objects work in load-balanced systems either, I believe they are server-specific, and the forum does use Application variables. Search the forums here for a thread on this subject, someone got it working by cloning the application between servers.