The Xml field in SQL database is so slow!

I feel when I operate XML field, it's so slow! no matter insert or delete e a record. how about you

Sumit2006
I made a online bookmark program with ASP.Net 2.0+ SQL 2005, I stored bookmarks in a XML Field, I find it's very slow when I insert, edit or delete bookmark, especially import bookmark to a folder selected.you can try it at http://www.hellocw.com/onlinebookmark/Default.aspx
CaiCheng

Hi!

Could you send your scenario and tell what are your expectations

We can try to meditate on this with our performance team.
D13G0
Please describe some details about your application from data schema and access pattern perspective.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

What’s the schema of your data What do you store in one XML instance How do you store folder hierarchy

What kind of DB transaction folder operations or bookmark operations translate into

What performance do you observe and expect

Thank you and best regards,

Eugene Kogan

Technical Lead

SQL Server Engine
camus

I sometimes feel it is very fast :-).

Could you please be a but more specific on exactly what you do and how you have setup your data and log files

With more information, I am sure we either can help you, or file a performance bug...

Thanks

Michael
The Xml field in SQL database is so slow!