开发者

100k+ Records and sp_xml_preparedocument

开发者 https://www.devze.com 2023-01-02 21:04 出处:网络
I\'ve been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted,

I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on ave开发者_如何学运维rage. Is it possible that it is causing the deadlock? What other pitfalls does using sp_xml_preparedocument have?

For future reference, I'd also like to know what other things I should consider before rushing in and using sp_xml_preparedocument

0

精彩评论

暂无评论...
验证码 换一张
取 消