March 15, 2004 at 2:12 pm
I am doing a little bit of research and I am wondering if anybody is using msde as the backend database for web-based business applications. Is it valid under the msde licensing agreement and are there any performance issues you have with it?
thanks in advance
Billy
March 15, 2004 at 2:33 pm
You should be able to do this, but keep in mind MSDE dies at around 5 users, which is easy to use unless you are talking very small scale web app.
March 15, 2004 at 8:24 pm
Use MySQL for this purpose -- you will not be disappointed...
Arden
March 16, 2004 at 4:10 am
I agree, you will not be disappointed .....
Unless you want to do more than just Mickey Mouse queries, such as subselects and many other SQL compliant functions than MySQL does not support.
You will be able to work around these faults sure, but you cannot expect to convert MS-SQL quereies to MySQL without significant rewriting.
March 16, 2004 at 7:32 am
I don't know if you had found this article in your research, but I found it quite interesting.
http://www.ftponline.com/wss/2001_12/online/online_eprods/sql_rjennings12_4/
March 16, 2004 at 8:18 am
Here's a great article on MSDN about using MSDE 2000 in a web application. It describes how to get around the connection limit by setting the Max Pool Size for ADO.NET:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde2kwrk/html/msde2000webapp.asp
March 18, 2004 at 6:23 am
You need to read up on msde. If you use msde2000a it can support up to 25 connection. I fyou useing one or two connection strings that you the same user you can get away with alot. Like on ours we do over 17,000 hits a month and web pages are dynamic from the database.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply