MSDE questions: # of users, a good web solution? 1

[Webnewbie]

Does MSDE now support 25 users? (But no greater). Also has anyone used MSDE as a back-end on a webserver so the ASP code on the webpages communicates with the ASP.dll and then MSDE?

I'm thinking of going with either MSDE or mySQL as the backend. MSDE is hard for me to use because I don't know SQL-Server, I find I just can't program in Access as I used to when the back end is MSDE. It's interesting to figure out and learn...but I don't have that amount of time for my current project.

handle - "Webnewbie"

 

[nigelrivett]

>> Does MSDE now support 25 users? (But no greater). Also has anyone used MSDE as a back-end on a webserver so the ASP code on the webpages communicates with the ASP.dll and then MSDE?


Yes (it always has) and Yes.
MSDE is governed to slow sown when it has more than 5 concurrent threads (that's not connections they have to be executing).
With a web app you would normally deisconnect after every query and use connection pooling anyway - just limit the pool to 5 connections. This should be more than enough for 25 users otherwise do a bit of redesign.
It has the advantage over mysql in that it can be implemented free of charge and is the same engine as sql server so that it will be easy to scale in the future if you need it.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[RITE1]

As stated above, the MSDE version of SQL Server is throttled at five concurrent T-SQL operations. Does anyone know how bad the preformance losses are???

Another note for you webnewb, MSDE is limited to a 2 gig max database size.

 

[zhavic]

Does anyone know how bad the preformance losses are???

I red somewhere that:

When there are 5 concurrent T-SQL operations running, and
another T-SQL operation becomes, it waits for one of that 5 operations finished, and than it is executed.


Zhavic




---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.