Results 1 to 2 of 2

Thread: MTS and Batch processing

  1. Apr 16th, 2001, 05:04 AM #1
    TheWarnster
    TheWarnster is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2001
    Posts
    23
    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!
    Reply With Quote Reply With Quote
  2. May 7th, 2001, 03:16 PM #2
    rafaelc
    rafaelc is offline
    New Member
    Join Date
    May 2001
    Posts
    15
    There is significant overhead if you pass them one at a time, I would use a disconnected recordset and sen them all at once....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width