Friday, March 16, 2012

massive number of rows Inserting to database.

HI guys..
i am trying to insert around 50,000 records to sql database..
i am getting Server Application Unavailable message..
if i insert 25000 records..i don't get an error message..
is there anything i can control server time out or something?

thanks..server.scripttimeout = #of seconds for timeout

just like classic ASP
One of the ways to overcome the server time out is using threading. Put the function that inserts records on a thread.

Hope that helps

Anil

0 comments:

Post a Comment