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?

[102 byte] By [CUIWEI] at [2008-2-27]

«« database
»» datasource configuration wizzard

# 1

Hi!

Could you send your scenario and tell what are your expectations?

We can try to meditate on this with our performance team.

VadimTryshev-Microsoft at 2007-10-7 >

top of Msdn Tech,SQL Server,SQL Server XML...

# 2

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

MRys at 2007-10-7 >

# 3

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

CUIWEI at 2007-10-7 >

# 4

Please describe some details about your application from data schema and access pattern perspective.

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

EugeneKogan at 2007-10-7 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'The Xml field in SQL database is so slow!...'

The Xml field in SQL database is so slow!

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified