Just wondering what sort of prepared statement support there is with
Rose...
a- does rose call any DBI prepares
dbh->prepare(xxx)
dbh->execute(xxx)
if so, does it DEALLOCATE the statement handle?
b- does rose support calling any manual prepares?
i'm thinking about migrating to pg_pool. under my current setup i
require 150 postgres connections ( 75 apache servers running
Apache::DBI * 2 DB connection handles ( transaction safe reader /
writer AND autocommit session/visit logger ) that's down from 300
connections when everyone ran on their own isolated handles
( i had a cluster of 2 db machines. which are down to 1 right now )
with pg_pool I *should* be able to just use 25 connections on each of
4 handles and be more than happy -- or even just pipe everything
through 4 connections if i wanted. DBI seems to be ugly with pg_pool
under a lot of conditions though.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
