Re: Large selects handled inefficiently?

On Wed, Sep 06, 2000 at 09:33:07AM +0100, Jules Bean wrote:
>
> No, it's not really the DBD driver's fault. There is no (easy) way
> around it, since the flaw lies in the C library it uses. If the DBD
> driver wished to change behaviour, it could 'secretly' use cursors,
> but that would involve parsing queries to detect selects, which might
> be fragile.
>

Recent experience points out the fragility: the ODBC driver has an option
to try this: and there was just a bug report involving the driver's
attempts to use cursors with SELECT FOR UPDATE.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005