From my point of view it will be just fine to use an embedded DB like the SQL CE to small sites.
SQL CE performance is slower than MSSQL/MySQL but when you developed a small site there should be no problem. (if it's not more than a 1000 nodes you should be good by using the SQL CE database)
And by choosing theSQLCEdatabase, you can alwaysmigratethe database to a MSSQL database later in the future if necessary.
6.1.6 Embedded DB, content gone
Hi all,
Maybe you can help me out? I have installed a 6.1.6 using an embedded DB - no worries!
But today when working on the site, out of nowhere the DB was flushed leaving me with a total blank pages and media section?!
What to do?
Is embedded DB just a bad way to go (its a quite small site)
Is there anyway to reconnect to the DB?
Thanks in adv.
Hey, welcome to the forum.
Are you sure the db has disapeared? Could be a permissions problem, try to convert the db to the full version and check the content.
Rich
Hi Regin,
From my point of view it will be just fine to use an embedded DB like the SQL CE to small sites.
SQL CE performance is slower than MSSQL/MySQL but when you developed a small site there should be no problem. (if it's not more than a 1000 nodes you should be good by using the SQL CE database)
And by choosing the SQL CE database, you can always migrate the database to a MSSQL database later in the future if necessary.
Hope this is useful information.
/Dennis
is working on a reply...