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.