Re: Ado, Transaction, Multiline statements?
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/26/05
- Next message: Brian Bushay TeamB: "Re: Updating Access database used by ISAPI DLL"
- Previous message: Rick: "Re: Ado, Transaction, Multiline statements?"
- In reply to: Rick: "Re: Ado, Transaction, Multiline statements?"
- Next in thread: Del M: "Re: Ado, Transaction, Multiline statements?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Brian Bushay TeamB: "Re: Updating Access database used by ISAPI DLL"
- Previous message: Rick: "Re: Ado, Transaction, Multiline statements?"
- In reply to: Rick: "Re: Ado, Transaction, Multiline statements?"
- Next in thread: Del M: "Re: Ado, Transaction, Multiline statements?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]