Re: Ado, Transaction, Multiline statements?

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/26/05


Date: Tue, 25 Jan 2005 20:34:15 -0600


>Basically this is a massive data processing application. I connect and
>cache the cost files (and their supporting files), then process around
>45,000 records. Each of those records produces one master record (with
>totals) and
>a block of detail records (20-30 detailed costs). Currently it takes just
>under 4 hours to run, and the output table formats were specified in the
>project requirements.

In that case what you are doing sounds like a good way to go.
You can execute a query with TadoConnection.execute method and cut out a little
overhead.

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com