-
1. Re: Slower JDBC after migrating from JBoss 4.2.3 to Wildfly 9
jim_b_o Dec 8, 2015 3:52 PM (in response to anhh)You might benefit from:
<statement>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
And possibly enlistment-trace="false" although I'm not sure if that exists before WildFly 10. But if it does, I think it's good with use-ccm="false" for those good developers who clean up their own connections.
-
2. Re: Slower JDBC after migrating from JBoss 4.2.3 to Wildfly 9
jim_b_o Dec 8, 2015 4:02 PM (in response to anhh)Maybe also test using one of the Postgres DataSources rather than the Driver. Like you, I used to use the Driver (MS and JTDS) with JBoss 4.2.3 (don't remember why) but have switched to the Connection Pool DataSources with WildFly 10.
-
3. Re: Slower JDBC after migrating from JBoss 4.2.3 to Wildfly 9
anhh Dec 9, 2015 4:50 AM (in response to jim_b_o)Thanks James, I'll take a look into your suggestions and let you know.