Le jeudi 22 août 2013 à 00:08 +0200, David E. Wheeler a écrit :
> 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
Apache is configured with MaxClients=1, so that only one process is
active.
There should be only two cached handles (one with
private_preferred_datestyle ='iso', one 'SQL, dmy') :
'cachedkids' => '$VAR1 = {
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fb1c480)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919faf2c78)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fad0768)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fb0dd68)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='SQL,
dmy'\' => bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fb0d000)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fb2c9f0)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fa76b88)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='iso'\'
=> bless( {}, \'DBI::db\' ),
\'dbname=aspro!www-data!!AutoCommit='1',Callbacks='HASH(0x7f919fab1d00)',PrintError='1',RaiseError='1',Username='www-data',dbi_connect_method='connect_cached',pg_bool_tf='t',private_preferred_datestyle='SQL,
dmy'\' => bless( {}, \'DBI::db\' )
};
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contrats, des contentieux juridiques et des sinistres
d'assurance
