On Fri, 14 Dec 2001, Benjamin Franks wrote:
> The results are the same in the database either way. From what I can
> tell, it did not speed up. In fact it actually slowed down. The SQL
> statements haven't changed at all and I haven't changed the database
> schema, version, configuration options, etc.. I would have imagined
> the second sequence would have been much faster because needless SQL
> isn't being done inside the inner loops. Does anyone have any ideas
> as to why this would be the case? Could it have to do with moving
>From perldoc DBD::Pg:
prepare
$sth = $dbh->prepare($statement, \%attr);
PostgreSQL does not have the concept of preparing a
statement. Hence the prepare method just stores the
statement after checking for place-holders. No
information about the statement is available after
preparing it.
HTH,
-Rudy
