Timeout issue
Problem: I have a collection of multipage containing dozens of controls like checkboxes, textboxes, and radiobuttons.
I reckon a total of more than 500 !
I have a Save button sending the content of one page to my database. The point is that I do some generic code to loop through the controls collection, and save to the database through a stored procedure.
I wanted to have a Save ALL button. The loop is almost the same embedded in a page loop.
I experienced here some random timeout, indeed depending on the network traffic (it's an Intranet application shared by 6 users).
So my question is : what strategy should I use to to save everything ?
I was thinking about transactions, but I hav the feeling that the problem must reside with the For each...loop.
On top of that, the trace mode show me some huge differences between two servers, one running at 1 Ghz, the other one at 2 Ghz. It's really one to two !
If you have some suggestions, let me know.