> From: Perrin Harkins [mailto:[EMAIL PROTECTED]]
> On Tue, 28 Nov 2000, Stas Bekman wrote:
> > And fetch()es are quite irrelevant for performance
> improvements since they
> > never change unless you compare TCP/IP vs UNIX sockets or one driver
> > against the other.
>
> I find the fetch information useful when deciding whether to do a more
> complex query that retrieves fewer results or a simple one
> that retrieves
> extra data and then sift through it in perl.
For some drivers (DBD::Ingres for one) the $sth->execute only optimizes the
query, the data is fetched in the first call to fetch. Fetching the first
row does all the "real" work, joining and sorting etc.
So you will se a very fast prepare time, a not-too-long execute time, and
(in some cases) a horribly long fetch-time for the first fetch.
--
Henrik Tougaard, [EMAIL PROTECTED]
DBD::Ingres maintainer.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
