What are SQL CE limits & preferences?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
6/22/2012 7:14:29 AM
Eugene
Gravatar
Total Posts 15
View Posts

What are SQL CE limits & preferences?

Joe, please tell about SQL CE limits for now. Somewhere in documentation I found words about that only pulls & surveis (what is it?) can work on MS SQL & MySQL db engines. But in another pice of docs I found words that WebStore can work only on MS SQL & MySQL db engines too. But I need WebStore! What are real limits for SQL CE for now. I like simplicity of using my local none-server db because it some simply administrate, upload, hosting changing etc (and because of possibility of moving db data to MS SQL). Also if can do it please tell about preferences of using SQL CE vs MS SQL.

6/22/2012 1:36:26 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: What are SQL CE limits & preferences?

SQL CE is very convenient for deployment and is ok for small to medium traffic sites but is not anywhere near as robust as SQL Server. For a serious business class web site I would use MS SQL. You will get much much better performance and stability with SQL Server.

If you need WebStore that is another reason to go with SQL Server, because we don't have a data layer for WebStore implemented for SQL CE and there are no plans to implement that any time soon.  WebStore is a relatively immature feature, when it becomes more mature we may implement some additional data layers but that is probably a long way in the future. If we implement more data layers now it becomes more work to evolve the feature and make changes and would only slow down progress. Besides that ecommerce is business and I would not run my business on SQL CE, so that would be a low priority for WebStore.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.