Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kate 267 posts 610 karma points
    Apr 24, 2013 @ 14:42
    Kate
    0

    sql CE 4 vs. MySql

    Hi

    I just tried to install an Umbraco 6.0.3 and I could not get it to approve a MySQL database which I have done before in previous Umbraco versions.

    What I really want to know is whether a SQL CE 4 is safe enough to use and function just as well as a MySQL?

    It seems incredibly easy to use the SQL CE 4 - almost too good to be true - so I just want to hear your opinion on the 2 databases.

    / Kate

    Copy Link
  • Jan Skovgaard 11258 posts 23500 karma points MVP 7x admin c-trib
    Apr 24, 2013 @ 15:00
    Jan Skovgaard
    1

    Hi Kate

    How big do you expect the site to become? SQL CE performance is slower than MSSQL/MySQL but if it's a small site then it may not be a problem.

    However there are some issues with MySQL in v6, which you can see a bunch of here http://issues.umbraco.org/issues?q=mysql

    Perhaps some of the issues reported can help you figure out how to get v6 running on MySQL.

    Hope this helps.

    /Jan

    Copy Link
  • Kate 267 posts 610 karma points
    Apr 24, 2013 @ 15:07
    Kate
    0

    Hi Jan

    Thanks for your reply
    Would you use SQL CE 4 to one of your customers even if it is a small site?

    /Kate

    Copy Link
  • Jan Skovgaard 11258 posts 23500 karma points MVP 7x admin c-trib
    Apr 24, 2013 @ 20:58
    Jan Skovgaard
    0

    Hi Kate

    It depends what you define as a small site - if it's not more than a 1000 nodes I don't see why not? :)

    /Jan

    Copy Link
  • Sean L 24 posts 146 karma points
    Apr 25, 2013 @ 14:56
    Sean L
    1

    Kate,

    Hopefully this is some helpful information, but if you do decide to go with SQL CE 4, you can always migrate the database later, if necessary. I had a site that started as SQL CE 4, but at the pace it was growing, I decided to go ahead and make the migration while it was still relatively small. In my case, I migrated the database to MSSQL.

    Definitely creates more work in the long run, but just wanted to point out that you can do a migration in the future if necessary.

    Cheers

    /Sean

    Copy Link
  • Kate 267 posts 610 karma points
    Apr 25, 2013 @ 15:20
    Kate
    0

    Thanks to both of you
    I will start with an Umbraco 4.11.6 and use MySQL as I know for my customer.
    Later I will make a test site and get tested Sql CE 4
    Thank you to both of you :-)

    /Kate

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies