February 3, 2006 at 9:21 am
Got a question for anyone who has some input. My development team and I are looking at reworking our base architecture to use the new features of SQL 2005 and .Net 2005. Currently, the entire framework is built on XML usint FOR XML Explicit in the all queries. All data going to and from the databse is passed through XML.
We're wondering if anyone has actually bench-marked the speed of XML vs DataReaders. Including the SQL Server query speed and processing speed of the app/web site.
Looking for any input or even just theories.
February 6, 2006 at 8:00 am
This was removed by the editor as SPAM
February 7, 2006 at 7:30 am
Based on my experience, datareader is definitely faster. FOR XML adds loads in database side to build it and loads on app side to parse it (or deserialize it) to dataset.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply