-
Hi all,
A quick question.. I have a 3 tier application that needs to process individually approx 350000 records.
The application has a server component residing in an MTS cmponent.
The question is. Should i pass the records one at a time to the server component from the client. OR pass them all at once to the Server component and let that do all the work.
The problem with this method is that i find that the MTS transaction Times Out.
So Gurus which way is the best and how do i do it!!
Many thanks in advance!
-
There is significant overhead if you pass them one at a time, I would use a disconnected recordset and sen them all at once....
