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.

No Comments