开发者

Umbraco - SQL Server or SQLCE4? Performance and upgrade considerations

开发者 https://www.devze.com 2023-02-12 07:03 出处:网络
I am creating a customer site with the Umbraco CMS. the cheapest database option is to go with SQLCE4, as the latest version supports this.

I am creating a customer site with the Umbraco CMS.

the cheapest database option is to go with SQLCE4, as the latest version supports this.

What concerns me about using SQLCE4 is the performance....

how many concurrent users before it starts to top out?

if i did need to upgrade to full SQL Server in the future would i be able to port all of开发者_开发知识库 my data over?

is the schema exactly the same for the sql server version and SQLCE4 version? because SQLCE does not support stored procedures or views.


If you are worried about having an upgrade path, you could consider SQL Server Express (which is also free), and the upgrade (if you ever need it) would be as painless as shelling out some bucks. I am using SQL Express 2008 on one of my Umbraco installs, and the performance is more than fine. (Though this is not a high traffic site).

CE I beleive uses a SDF file format that is not compatible, the MDF file that expressSQL uses is the same one that the bigger versions of SQL server use. The upgrade would be a nobrainer.

I'd say the schema is the same - umbraco has no views or stored procedures by default.

0

精彩评论

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