mohd.nizamuddin (8/18/2009)
Lee Forst:I haven't tested for it that much records, but our application is working fine dealing with upto 400 - 500 records in an XML.
Will test for more records and post the result.
Hi Lee,
I tested for some 10000 records in XML approach, though my test table has only 3 columns, and it took just 1 sec to complete the insertion.
(Testing Environment: SQL Server Express 2005, P4 2.8GHz, 2GB RAM.)