开发者

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

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 doin开发者_高级运维g 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?


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜