This project is read-only.

Indexing XML data

Jan 7, 2012 at 9:03 PM

Hi,

I have found nHydrate to working perfectly for everything i want apart from when dealing with XML columns. I have got the xml been loaded and saved correctly and i use custom stored procs to do searches based on the xml but i have not had very good performance.  I assume this is because of the fact that there is no indexs on any of the xml nodes i am using in my search.  While SQL supports these indexes i can not work out how to added them into the code so that the nHydrate DB installer will run and maintain the indexes for me like it maintains the rest of my database.  Can you point me in the right direction for creating custom indexes/sql code that the DB installer will run?

Jan 7, 2012 at 9:42 PM

Also telling nHydrate to put an index on an xml column results in an error saying only xml indexes can be put on an xml column so it seems it trys to add the wrong index.