Database interface
Tom Pledger
Tom.Pledger@peace.com
Fri, 22 Aug 2003 09:49:15 +1200
Tim Docker writes:
:
| Is it normal or common to support multiple simultaneous queries on
| a single DB connection?
In transaction processing, yes. There's an idiom where you use one
query to select all the (financial) transactions in a batch, but
there's so much variation in how you need to process each row, that
you can't express it all in one SQL query. So you use a variety of
little queries during the processing of each row of the main query.
The result of the fold in your doquery could be, say, a record of
batch totals.
- Tom