Is SQL Server Compact *ever* OK to use on a web server?

Question

I'd like to host a personal database for about 500 people (1 database per person) on my web server. A person could possibly share their database with a friend or two. On my web server, I'd have some web services, perhaps for doing synchronization, and maybe even an ASP.NET Web Forms front end to the database.

If I restart my IIS web server, would this likely cause database corruptions? Would this be expected to perform ok?

If not Compact, should I instead use SQL Express and create a database in SQL Server for each of my 500 people?

Answer 1

It looks like ScottGu says it's OK: http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx