what is the best way to execute a time consuming function

See more:

VB

ASP.NET

SQL

Hello,

I have a page in asp.net that execute a function that generate a query to update multiple row from a database

that function is taking a long time to finish which lead to a "The wait operation timed out" exception

what is the best way to execute this function and jump over the time out exception that the system throw on long time execution

suggest me options to deal with such problem.

note that my database has large amount of data and this error appears when updating multiple rows

the query that im using is :"

Update Emails Set Status='Active' Where ID in (" & hardmailsIDs & ")"

the function vb that is used to get those ids in a string (hardmailsIDs) using a loop ..

For Each dr As DataRow In hardbouncedmail.Rows
                   hardmails = (hardmails & Convert.ToString(",")) + "'" + Convert.ToString(dr("Email") + "'")
                   Dim IdRow() As DataRow = selectedmailIDs.Select("Email='" & dr("Email") & "'")
                   hardmailsIDs = (hardmailsIDs & Convert.ToString(",") + IdRow(0).Item("ID").ToString())
               Next

the number of id may reach 50,000 row

thanks.