Blog is by default using XML backend.

Topics: Themes
May 27, 2012 at 6:55 AM

While setting up my BlogEngine 2.5 blog, I made changes to use SQL Server database instead of XML. I found after couple of months that it is using XML to store blog posts.

Is XML slower than SQL Server? Anyway to migrate all my XML posts to SQL Server and use the latter as default?

Coordinator
May 27, 2012 at 12:38 PM

There's an old tool which is out-of-date that could be used as a starting point for changing to a different provider (link below).  The tool was created a few versions ago, and doesn't take into account some of the newer types of data that are saved ... although it does cover the major ones.

The way BE is designed, I don't think there is any speed difference between XML and SQL Server.  The reason is because BE loads all your data into memory when the blog first loads, and then only accessed the data store (App_Data or SQL Server) when it needs to save data.  So when data (blog posts, etc) are being accessed on your site, they are always coming from memory and the backend data store is not being used.

BlogEngine.NET Provider Migration
http://www.nyveldt.com/blog/page/BlogEngineNET-Provider-Migration.aspx