Hello,I'm wondering if some other people here have some wisdom about this case a few people have run into, apparently with no resolution.
Newer versions of DBD::Pg and PostgreSQL support a feature called "server side prepares", which is supposed to give a significant performance boost in some cases.
However, when deploying it on mod_perl on a busy website, I quickly saw a lot of this kind of error:
prepared statement "dbdpg_7" already exists Other people have run into this as well: http://gborg.postgresql.org/pipermail/dbdpg-general/2005-December/001926.htmlAny suggestions? I looked at the DBD::Pg code myself, but my C skills aren't up to digging into the XS code there.
I found a related mention of this issue here:
http://fudforum.org/forum/index.php?t=msg&th=4598&start=0&
There the fix involved putting using DEALLOCATE when persistent
connections are detected. The actual patch they used in their
application was here:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=10611
Thanks!
Mark
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.