Change Data column to xml type

Topics: Core
Feb 23, 2015 at 6:42 AM
We are doing some reports and have stored procedures that query the Orchard database, there is a big speed improvement if we changed the type of the Data column in the Orchard_Framework_ContentItemVersionRecord table to xml. In brief testing there doesn't appear to be any issue with the Orchard web site.

Has anyone else had a look at changing the type of this column?
Feb 27, 2015 at 3:19 AM
Very interesting, I've tried to use the xml type for this column. Tested on projections of a few items, it was faster than before. But when I reverted back to the nvchar type it kept the same performance. So, maybe it's only because the table has been dropped and re-created

Did you try to revert back to nvchar type? If so, was it still slower?

Best
Feb 27, 2015 at 3:25 AM
Yep, pretty consistent, slow with nvarchar and quick with xml.

With the next Orchard project we do we'll look at setting the column to xml, for the current project we are just about to deploy it and so can't afford to change the type and do a complete test.