Connection duration

Hi,

I need to write a COM that will do some data transfer from one server to the other. This COM will run on MTS.

As advised from M$, it is better to use Client-Side recordset, and make the connection duration as short as possible.

My problem is that, I must use Server-side recordset and also the process may lasts for over one hour.

Since there are many other apps that have COM running on that MTS too, will this be a great performance impact to other apps?

Thx

In one word - yes. You are gonna kill the server. I know because I did it once.

Hi,

Then what can I do? In my situation, I can't use Client-Side recordset or I won't be able to update it.

Can I split the download processing into certain pieces (say 5 simultaneously download instead of 1)??

I must use Server-Side recordset and long duration........please advise!!!!

Thx a lot!