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