Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XML Bulk Load performance

Status
Not open for further replies.
markt101

markt101

Programmer
May 19, 2003
1
GB
I'm trying to use the XML Bulk Load Component to load a very large XML document into SQL Server 2000 on a regular basis. While it is importing the file successfully it takes an unfeasible length of time.

I was wondering if anyone can suggest methods of tweaking XML Bulk Copy performance?

I have already specified the ForceTableLock = True. I would like to specified an Insert Batch Size option but that does not seem to be available for XML bulk copy and as a result the transaction log is being hammered. I also have an extended period after the records have been inserted when the memory on the client machine tied up, can anyone suggest how i might find out what is going on?

Thanks
Mark.
 
Status
Not open for further replies.

Similar threads

gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
347
grnzbra
grnzbra
ahmedsa2018
  • Locked
  • Question
How to change STRING_AGG to stuff xml to split feature value by pip?
Replies
0
Views
324
ahmedsa2018
ahmedsa2018
ElEye
  • Locked
  • Question
Parse XML via SQL query 1
Replies
1
Views
323
gmmastros
gmmastros
bmacbmac
  • Locked
  • Question
Inserting XML data into SQLServer returns only NULL values 1
Replies
3
Views
432
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top