[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: issue with DBD::Pg, server side prepares, and persistent connections?


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


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.