memusage/performance of dbi

From: Larry (surfunbear_at_yahoo.com)
Date: 07/19/04


Date: 19 Jul 2004 07:42:17 -0700

using something like bind columns, can the performance of
returning results from a very large result set using perl/DBI
approach C++ with odbc ?

 With an extremely large result set, is the result set stored in
memory or streamed out of the database ? Iam asking because I would
like to know if there
could be a memory usage problem. Could the result set coming out of
the database overrun the application ? I would like t o think not, but
I need to ask these questions. How can I determine that sort of thing
or where can I look for answers ? I can't disclose everything our
company is using unfortunately as part of the question as it's not
allowed by the company.