Running a Long Batch Job in MTS

[MrRoper]

Hi everyone.

I have a 3 tier application that needs to process a batch of approx 54,000 records.

I have code in place that sends each record from the client to the buisness layer which resides in MTS.
This means that each individual record is processed as 1 transaction.

This method works but takes approx 15 minutes to run.

What is the proper method to do this via MTS???

I have tried to process all the records in one transaction but the transaction times out because it takes so long!!

Any help would be much appreciated

 

[jmarler]

What part of it times out? The DB connection? Or a web interface? Or the actual component? What part is it?
If it's just a web interface that is timing out, then consider using MSMQ to make the call asynchronous. The UI would place a message in the Queue and a service running on the server would respond to the message and begin processing. In the meantime, the UI would return and inform the user that processing has begun.
- Jeff Marler B-)

 

[zallen]

You can disable the time out by setting it to zero in MTS explore.

Regards! zallen@cmmail.com
ICQ:101229409
Long live of freedom!

 

[jmarler]

What Zallen suggested will work fine (setting the timeout to 0 in the MTS explorer) if it is only the transaction that is timing out. - Jeff Marler B-)

 

[dwhdwh]

I do no set the timeout to 0, as this affects all packages in MTS. You can turn off transaction support for a particular package, and then it will not timeout. You will have to manage your own transactions here though.

 

[AkshayB]

You can use the transaction not supported for this object.
Means you have to run this object independently.
After the batch process the object can return success flag
to your application.