The time taken for insertion/update also depends on the size of the table, how is it indexed etc.

If you are interested, you can also try the SQL XML 3.0 bulk...

thanks colin.

I'm not using sp_xml_preparedocument. I'm using SQLXML 3.0 bulk copy.

I have requested for 1GB more RAM so that I can make use of /3G switch. I'm waiting for this.

Thanks...

Philip,

Thanks a lot. I appreciate your help.

Both my boxes are dedicated for running sql servers, have 2 cpus, parallel processing enabled on both. (though I'm not sure if parallel processing...