Web Wiz Support and Community Forums : WWF and Microsoft SQL Server 2005 Express Edition https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:26:34 +0000 Tue, 17 Jan 2006 12:45:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17771 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : From MS&#039;s web site thats...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97522.html#97522 Author: WebWiz-Bruce
Subject: 17771
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
]]> Tue, 17 Jan 2006 12:45:15 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97522.html#97522 <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : You would think that they would...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97488.html#97488 Author: wistex
Subject: 17771
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 somemore digging.  But that does let me know what I need toknow.  Thanks.
]]> Mon, 16 Jan 2006 19:38:52 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97488.html#97488 <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : This site uses an MSDE database...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97468.html#97468 Author: WebWiz-Bruce
Subject: 17771
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.
]]> Mon, 16 Jan 2006 17:07:24 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97468.html#97468 <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : Ifwe have a decent web server,...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97319.html#97319 Author: wistex
Subject: 17771
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?
]]> Sun, 15 Jan 2006 01:03:08 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post97319.html#97319 <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : Web Wiz Forums runs fine under...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post96530.html#96530 Author: WebWiz-Bruce
Subject: 17771
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 currentlyrun on 1 MSDE database without any problems, with further throttlingdone 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 limitationon concurrent users on MSDE will not effect performance as websitestend to have 1 username under which it connects to the database, thismeans 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 thedatabase to my office server more difficult.


Edited by -boRg- - 07 January 2006 at 2:10pm]]> Sat, 07 Jan 2006 14:10:11 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post96530.html#96530 <![CDATA[WWF and Microsoft SQL Server 2005 Express Edition : Does anyone have any thoughts...]]> https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post96493.html#96493 Author: Rider
Subject: 17771
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?

]]> Fri, 06 Jan 2006 19:09:16 +0000 https://forums.webwiz.net/wwf-and-microsoft-sql-server-2005-express-edition_topic17771_post96493.html#96493