Re: Shorthand for $dbh->prepare and $sth->execute?

[Tim Bunce]

On Tue, Jun 26, 2001 at 11:48:34PM +0800, Orlando Andico wrote:
> 
> and definitely, the execute part took longest.. if what you're saying is
> true, execute would return immediately and let me fetch records at will.
> That does NOT happen. execute takes forever, THEN i can fetch records.

That's probably because DBD::Oracle uses the 'execute and fetch' OCI call
that combines an execute with a fetch of the first row. That's what most
people want most of the time and reduces the round-trips to the server.
Especially when selecting a small number of rows. Especially 1.

Tim.