XML Provider vs SQL Provider

Topics: ASP.NET 2.0, Business Logic Layer, Controls
Dec 30, 2012 at 5:29 PM

Can anyone advise on the differences in page speed performance between the SQL and XML data providers.

I assume SQL will be quicker once the website is running, but how does the initial connection to SQL server compare to the use of XML.

Does it depend on the size of the blog? ie is xml best for small sites, SQL bestfor large sites?

The reason I ask is due to the hosting costs.  I can use SQL server but is it worth it?

 

Jan 1, 2013 at 7:15 PM

I think it all depends on 1) how big is your blog (number of pages & posts) and 2) how much traffic you expect. I use XML and have never had performance issues, but then again I don't have many posts/pages and I average about 5K visits a month.