Web Wiz Forums - WWF and Microsoft SQL Server 2005 Express Edition

WWF and Microsoft SQL Server 2005 Express Edition

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=17771
Printed Date: 13 April 2026 at 6:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: WWF and Microsoft SQL Server 2005 Express Edition

Posted By: Rider
Subject: WWF and Microsoft SQL Server 2005 Express Edition
Date Posted: 06 January 2006 at 7:09pm

Does anyone have any thoughts about the feasabilty or desirability of running WWF under Microsoft SQL Server 2005 Express? Also, is it true that SQL 2000 Develoer Edition and MSDE have a limit of 5 activley concurrent connections? What does this mean for "real world" conncurrent usage of WWF based on these editions, and does that same limit apply to Microsoft SQL Server 2005 Express Edition?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 January 2006 at 2:10pm

Web Wiz Forums runs fine under both MSDE and SQL Server 2005 Express.

This forum you are presently on and the rest of this site currently run on 1 MSDE database without any problems, with further throttling done to keep the amount of memory MSDE uses to under 100Mb, and still most forum pages process in under 0.05 secounds.

Both MSDE and 2005 Express will run Web Wiz Forums fine, the limitation on concurrent users on MSDE will not effect performance as websites tend to have 1 username under which it connects to the database, this means that websites only require 1 concurrent user.

The only reason why I use MSDE and not SQL 2005 Express for this site, is that there are limitations on 2005 Express that make backing up the database to my office server more difficult.

-------------
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: wistex
Date Posted: 15 January 2006 at 1:03am

If we have a decent web server, will installing Microsoft SQL Server 2005 Express on the same server cause performance problems? We are running many dozens of websites, including a fairly busy website using WWF.

We are currently using a dedicated web server and a shared Microsoft SQL 2000 database on another computer and we are trying to eliminate the shared MS SQL Server either by switching to MySQL or MS SQL Server 2005 Express. Moving to MS SQL Server 2005 Express is more tempting since we wouldn't have to convert existing MS SQL code to MySQL.

Also, would upgrading to the Standard MS SQL Server 2005 be something easy to do if we decide to later go that route?

Whatever solution we use must work with Web Wiz Forums 8.x.

Suggestions?

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: WebWiz-Bruce
Date Posted: 16 January 2006 at 5:07pm

This site uses an MSDE database on the same server.

Currently there are 100 sites on the server, and this site has over 500,000 hits per day.

The MSDE database for this site is 80Mb in size and MSDE uses 250Mb if you let it but due to memory limitations I throttle this down to 100Mb so that it doesn't use to much memory.

I would imagine that SQL 2005 Express would preform pretty much the same way MSDE does on this site.

Moving from MSDE to any other version of SQL 2000 and 2005 is simple with DTS, but with SQL 2005 Express MS have placed limtations into it for moving database to other versions of SQL server, so I would check it out with Microsoft. This is the reason why I am sticking with MSDE at the moment.

-------------
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: wistex
Date Posted: 16 January 2006 at 7:38pm

You would think that they would make it easy to upgrade to a paid version....

Their website was kinda confusing about that so I will have to do some more digging. But that does let me know what I need to know. Thanks.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: WebWiz-Bruce
Date Posted: 17 January 2006 at 12:45pm

From MS's web site thats what I got, but I'm not 100% sure.

If you find you can move an 2005 Express database to SQL Server 2005 please let me know as I will then probaly upgrade to 2005 Express

-------------
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