Web Wiz Support and Community Forums : MSDE support? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 00:51:56 +0000 Thu, 18 Dec 2003 23:31:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=249 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MSDE support? : trendecide wrote:I&#039;ll...]]> https://forums.webwiz.net/msde-support_topic249_post42182.html#42182 Author: Tegwin
Subject: 249
Posted: 18 December 2003 at 11:31pm

Originally posted by trendecide trendecide wrote:

I'll toy around with it and let you know what I can come up with.

 

For what its worth, I have been using MSDE as a backend for the forum for a while now. It works like a charm...  As was mentioned in an earlier post, you will have to create the database first and then your away

 

 

]]> Thu, 18 Dec 2003 23:31:40 +0000 https://forums.webwiz.net/msde-support_topic249_post42182.html#42182 <![CDATA[MSDE support? : tmcquinlan wrote: MSDE was...]]> https://forums.webwiz.net/msde-support_topic249_post42115.html#42115 Author: thekiwi
Subject: 249
Posted: 18 December 2003 at 12:55pm

Originally posted by tmcquinlan tmcquinlan wrote:

MSDE was originally offered as a free developers version of SQL but is now often used for desktop apps that are designed for a single user.

The biggest reason you won't want to use it for a discussion forum is that it has an inbuilt maximum of 5 users.  It will allow more users to connect, but performance will be seriously, purposely, degraded over 5.

http://www.aspfaq.com/show.asp?id=2343

Specifically concerning the "concurrent users", the aboive statement is not 100% correct.

"MSDE 2000 allows 32,767 connections to an instance of the database engine. There is no limit for the number of connections that can be executing operations at the same time. The only effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time."

and

"Once it has been activated, the workload governor limits performance by stalling a user connection for a few milliseconds each time the connection requests a logical read or write on any of the pages in the data files of a database"

and

"When the number of active operations is eight or lower, the database engine does not wait before scheduling any reads or writes. When the workload governor is active, it equally affects all connections; it is not limited to slowing down only the connections that activated the governor. The length of the wait implemented by the governor is constant (it does not vary depending on how many operations are active beyond the limit of eight)."

Given that an "operation" will only last milliseconds anyway ... the impact when compared to an access database will be very very minimal.

Id consider MSDE a far better option than an access database

]]> Thu, 18 Dec 2003 12:55:40 +0000 https://forums.webwiz.net/msde-support_topic249_post42115.html#42115 <![CDATA[MSDE support? : MSDE was originally offered as...]]> https://forums.webwiz.net/msde-support_topic249_post1267.html#1267 Author: tmcquinlan
Subject: 249
Posted: 17 February 2003 at 8:44pm

MSDE was originally offered as a free developers version of SQL but is now often used for desktop apps that are designed for a single user.

The biggest reason you won't want to use it for a discussion forum is that it has an inbuilt maximum of 5 users.  It will allow more users to connect, but performance will be seriously, purposely, degraded over 5.

]]> Mon, 17 Feb 2003 20:44:35 +0000 https://forums.webwiz.net/msde-support_topic249_post1267.html#1267 <![CDATA[MSDE support? : I&#039;ll toy around with it and...]]> https://forums.webwiz.net/msde-support_topic249_post1264.html#1264 Author: trendecide
Subject: 249
Posted: 17 February 2003 at 7:59pm

I'll toy around with it and let you know what I can come up with.]]> Mon, 17 Feb 2003 19:59:14 +0000 https://forums.webwiz.net/msde-support_topic249_post1264.html#1264 <![CDATA[MSDE support? : though the forum does not create...]]> https://forums.webwiz.net/msde-support_topic249_post1213.html#1213 Author: michael
Subject: 249
Posted: 17 February 2003 at 2:54pm

though the forum does not create the database and MSDE does not come with client tools so either get some freeware app to create a db and a user or use osql, is just as good.]]> Mon, 17 Feb 2003 14:54:30 +0000 https://forums.webwiz.net/msde-support_topic249_post1213.html#1213 <![CDATA[MSDE support? : Then it should work, just download...]]> https://forums.webwiz.net/msde-support_topic249_post1170.html#1170 Author: WebWiz-Bruce
Subject: 249
Posted: 17 February 2003 at 11:50am

Then it should work, just download the SQL server version, and setup the right connection to the database.]]> Mon, 17 Feb 2003 11:50:05 +0000 https://forums.webwiz.net/msde-support_topic249_post1170.html#1170 <![CDATA[MSDE support? : ASP.NET forums use it as an alternative...]]> https://forums.webwiz.net/msde-support_topic249_post1167.html#1167 Author: trendecide
Subject: 249
Posted: 17 February 2003 at 11:41am

ASP.NET forums use it as an alternative to SQL Server...

http://www.asp.net/Forums/Download/default.aspx?tabindex=1

]]> Mon, 17 Feb 2003 11:41:39 +0000 https://forums.webwiz.net/msde-support_topic249_post1167.html#1167 <![CDATA[MSDE support? : If you mean the desktop version...]]> https://forums.webwiz.net/msde-support_topic249_post1163.html#1163 Author: WebWiz-Bruce
Subject: 249
Posted: 17 February 2003 at 11:37am

If you mean the desktop version of SQL server then it should be, but I'm not sure if you can connect to it using TCP/IP (mixed mode), which would mean it can't be used as a web backend database.]]> Mon, 17 Feb 2003 11:37:25 +0000 https://forums.webwiz.net/msde-support_topic249_post1163.html#1163 <![CDATA[MSDE support? : my understanding is that MSDE...]]> https://forums.webwiz.net/msde-support_topic249_post1156.html#1156 Author: trendecide
Subject: 249
Posted: 17 February 2003 at 10:50am

my understanding is that MSDE is a stripped down version of SQL Server, but it's free.  I'm not too familiar with it, but would it be worth supporting it in v7.0?

]]> Mon, 17 Feb 2003 10:50:29 +0000 https://forums.webwiz.net/msde-support_topic249_post1156.html#1156