开发者

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

开发者 https://www.devze.com 2023-01-03 11:03 出处:网络
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 w

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

精彩评论

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

关注公众号