PrepareStatementCache vs PostgreSQL Driver cache
18 views
Skip to first unread message
Mirek Sz
May 26, 2016, 7:38:56 AM5/26/16
to IronJacamar Users
Hello,
I'm using JBOSS 7.1 and have configured prepare-statement-cache and share-prepare-statement-cache.
In new Postgresql JDBC (9.4) driver has default enabled prepare statement cache.
What I need to do now? DIsable cache in pool or disable in driver or maybe there is some other options.
Best regards
Mirek
I'm using JBOSS 7.1 and have configured prepare-statement-cache and share-prepare-statement-cache.
In new Postgresql JDBC (9.4) driver has default enabled prepare statement cache.
What I need to do now? DIsable cache in pool or disable in driver or maybe there is some other options.
Best regards
Mirek
Stefano Maestri
May 30, 2016, 4:01:21 AM5/30/16
to IronJacamar Users
Configuration exposed in JBoss DMR/xml should be sufficient.
regards
S.
Mirek Sz
May 30, 2016, 8:36:41 AM5/30/16
to IronJacamar Users
So you suggest disable cache in driver? Because guys from JBoss made this better?
Stefano Maestri
May 30, 2016, 8:53:02 AM5/30/16
to IronJacamar Users
The point is not who is doing better, but normally it's better to have a single configuration point, and DMR permit you to have a single configuration for the entire domain, while configuring it in driver should be done in all deployed driver one for each server instance in the domain.
Moreover I'm not sure the driver has the concept of share-prepared-statements cache.
Hoping it helps
regards
S.
Reply all
Reply to author
Forward
0 new messages