On Aug 9, 2006, at 8:34 AM, John Siracusa wrote:
> Yeah, although many places use prepare_cached() instead. This
> choice can be
> controlled on per-class and per-call basis. Grep the docs for
> "prepare_cached" and "dbi_prepare_cached" to learn more.
ok. that works.
>> if so, does it DEALLOCATE the statement handle?
>
> I'm not sure what you mean by that. The $sth variables basically
> just go
> out of scope...
>> b- does rose support calling any manual prepares?
>
> Can you give me an example of what you mean?
A lot of prepared statements are emulated because db apps ( like
mysql ) didn't really support a prepare until recently, and few db
drivers supported an actual server side prepare. DBD::Pg just
emulated it until 1.4 by using internal representations.
a bunch of dbs work like this with server side prepares
prepare statement1 from 'SELECT NOW() as time_now'
execute statement1;
deallocate statement1; # removes the satement
so anyways, getting back to the point.... dbd automagically creates
prepared stuff
prepare ID from SQL
where id is just an internal counter on prepares. someone just
submitted a batch to make it prepare PID_ID , to avoid name clashes
under apache::dbi
i'm looking at migrating to Apache::DBI + PG pool-- instead of having
150 connections to PG, i have 150 connections to pg_pool, which has
25 postgres connections that it manages. under that scenario, any
sort of prepare is out.
since prepare statement handles are per-connection though, i was
thinking that there might be a way ( wishfully thinking ) to either
create handles on startup or specify the prepare statement name. i
now know thats not possible.
On Aug 9, 2006, at 12:42 PM, Perrin Harkins wrote:
> Won't that be the same as just turning off server-side statement
> handles?
i might just do that.
-------------------------------------------------------------------------
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
