Re: using callbacks with connect_cached

On Aug 22, 2013, at 8:28 AM, Vincent Veyron <[email protected]> wrote:

>> Try the connected callback, instead:
>> 
>>  http://justatheory.com/computers/databases/postgresql/execute-on-select.html
>> 
> 
> 
> Hi David,
> 
> I did study your fine article for my research, thank you for that :-)
> 
> But you must have overlooked the part of my post where I write that the
> connected callback creates a new handle for each query in the database;
> no caching happens as one can see with CackedKids after a few queries

Oy, yes, sorry, I did miss that.

> Apache is configured with MaxClients=1, so that only one process is
> active.

Stranger and stranger.

> There should be only two cached handles (one with
> private_preferred_datestyle ='iso', one 'SQL, dmy') :

So, do you get a new handle for every query *without* the callback?

Note that DBI will reset all the attributes every time connect_cached is called. Maybe you need to delete one or more of the attributes in a connect_cached.reused callback?

  http://www.justatheory.com/computers/programming/perl/dbi-connect-cached-hack.html

HTH,

David