Hi,

Using SharePoint object model is there is any way to bulk insert items in list fast.

I have 10000 records.

Thanks,

Siva.

Hi ,

you can use batch insert method.

• ProcessBatchData() method of SPWeb.

here is example for ProcessBatchData():

ProcessBatchData method takes XML format as input and it will directly communicate with SharePoint content database. <m:smallfrac val="off"><m:dispdef><m:lmargin val="0"><m:rmargin val="0"><m:defjc val="centerGroup"><m:wrapindent val="1440"><m:intlim val="subSup"><m:narylim val="undOvr"></m:narylim></m:intlim></m:wrapindent><m:smallfrac val="off"><m:dispdef><m:lmargin val="0"><m:rmargin val="0"><m:defjc val="centerGroup"><m:wrapindent val="1440"><m:intlim val="subSup"><m:narylim val="undOvr"></m:narylim></m:intlim></m:wrapindent></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac>
StringBuilder query = new StringBuilder(); query.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Batch>"); for (int itemCount = 0; itemCount < 100; itemCount++) { query.AppendFormat("<Method ID=\"{0}\">" + "<SetList>{1}</SetList>" + "<SetVar Name=\"ID\">New</SetVar>" + "<SetVar Name=\"Cmd\">Save</SetVar>" + "<SetVar Name=\"{3}Title\">{2}</SetVar>" + "</Method>", i, listGuid, someValue, "urn:schemas-microsoft-com:office:office#"); } query.Append("</Batch>"); spWeb.ProcessBatchData(query.ToString());

http://bharatpandey.blogspot.in/2012/11/bulk-insert-updatedelete-items-in.html

http://apmblog.dynatrace.com/2009/01/20/sharepoint-using-batch-updates-to-speed-up-performance/