Did y'all see the recent MSDN article on how to tweak MSDE to use it effectively for a web app?  I was kind of amazed that we published it, actually Smiley

"Using MSDE 2000 in a Web Application"

To cut to the chase, here's the sort of performance improvement you can get from MSDE:

http://msdn.microsoft.com/library/en-us/dnmsde2kwrk/html/msdeweb04.gif