On Sat, 2006-08-05 at 18:46 -0500, Mark Stosberg wrote: > So are you suggesting I should use: > > $dbh->prepare_cached($sql, { pg_server_prepare => 1 }, 3) > > ...throughout the web-app?
If you use prepare_cached, adding the 3 is the safest way to go. It avoids possible problems with accidentally reusing an active statement handle. This is mostly an issue for people using SQL generation frameworks though. - Perrin