I'm about to revamp my personal Umbraco-driven site into a portfolio/blog thing, and since MSSQL database support is expensive with my current host, I opted for the embedded SQLCE database.
Sadly MySQL does not work (uppercase/lowercase tablename issues), because the database server is Linux-based and the host is not keen on changing the server settings.
SQLCE works fine for internal testing, but I'm a bit worried about the performance when the site has, say, 30-40 concurrent users? I don't expect the number of users to ever reach that amount, but would be nice to be somewhat prepared for it.
SQLCE good enough for small site?
Hi guys!
I'm about to revamp my personal Umbraco-driven site into a portfolio/blog thing, and since MSSQL database support is expensive with my current host, I opted for the embedded SQLCE database.
Sadly MySQL does not work (uppercase/lowercase tablename issues), because the database server is Linux-based and the host is not keen on changing the server settings.
SQLCE works fine for internal testing, but I'm a bit worried about the performance when the site has, say, 30-40 concurrent users? I don't expect the number of users to ever reach that amount, but would be nice to be somewhat prepared for it.
Thoughts?
Have a wonderful weekend :) /Simon
is working on a reply...