We are about commence our first project / website using Umbraco. Silly question but how good is SQL 2005 Express for hosting a small website and is there any performance issues. The site will consist of publicly available financial info (pdf's) and images of staff with some live news rss feeds.
I am not an sql expert, but the thing with umbraco is that almost everything is cached in memory, so when browsing the frontend of a site, there will in general be very few calls to the database, so performance should not be too affected by the type of database.
You mention using a lot of PDF's. The media api in umbraco is one of the things that can use quite a few database calls, so you might want to have that in mind when designing the solution. For example, if you are inserting the links to media in the RTE, then there is no problem, but if you have a macro that loops through a media folder, that might need to be cached in order to not slow down the page.
You don't state how busy the site might be and any hosting details, however SQL Server Express performance should be in line with the standard editions, it is however limited to 1gb of ram and one processor (you might want to check this). On our installs of SQL Server Web Edition we set the maximum memory to under a 1gb anyway.
As Morten states, only the media items hit the database from a front end perspective so unless your site is getting a serious amount of hits it should be fine.
SQL Server Express 2008 is also free, unless you have a specific reason to use 2005.
Umbraco and SQL 2005 Express??
Dear All,
We are about commence our first project / website using Umbraco. Silly question but how good is SQL 2005 Express for hosting a small website and is there any performance issues. The site will consist of publicly available financial info (pdf's) and images of staff with some live news rss feeds.
Any help would be fantastic.
Best Regards Paul
I am not an sql expert, but the thing with umbraco is that almost everything is cached in memory, so when browsing the frontend of a site, there will in general be very few calls to the database, so performance should not be too affected by the type of database.
You mention using a lot of PDF's. The media api in umbraco is one of the things that can use quite a few database calls, so you might want to have that in mind when designing the solution. For example, if you are inserting the links to media in the RTE, then there is no problem, but if you have a macro that loops through a media folder, that might need to be cached in order to not slow down the page.
Hi Paul,
You don't state how busy the site might be and any hosting details, however SQL Server Express performance should be in line with the standard editions, it is however limited to 1gb of ram and one processor (you might want to check this). On our installs of SQL Server Web Edition we set the maximum memory to under a 1gb anyway.
As Morten states, only the media items hit the database from a front end perspective so unless your site is getting a serious amount of hits it should be fine.
SQL Server Express 2008 is also free, unless you have a specific reason to use 2005.
Rich
is working on a reply...