----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/38487/#review99554 -----------------------------------------------------------
ambari-server/src/main/java/org/apache/ambari/server/controller/ControllerModule.java (lines 265 - 266) <https://reviews.apache.org/r/38487/#comment156484> c3p0's default is to have this turned off. I think they use an odd approach to caching statements which is why it could potentially harm the performance of an application. I'm wondering if we need to either: 1) Get some performance metrics to figure out the right value or 2) Disable them by default - Jonathan Hurley On Sept. 18, 2015, 9:24 a.m., Oliver Szabo wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/38487/ > ----------------------------------------------------------- > > (Updated Sept. 18, 2015, 9:24 a.m.) > > > Review request for Ambari, Jonathan Hurley and Robert Nettleton. > > > Bugs: AMBARI-13036 > https://issues.apache.org/jira/browse/AMBARI-13036 > > > Repository: ambari > > > Description > ------- > > Problem: > > Ambari does not cache database statements which leads to excessive parsing. > > Solution: > > Added internal and external statement caching feature to Ambari. Caching used > by default > > > Diffs > ----- > > > ambari-server/src/main/java/org/apache/ambari/server/configuration/Configuration.java > e3686ac > > ambari-server/src/main/java/org/apache/ambari/server/controller/ControllerModule.java > a40fae6 > > ambari-server/src/test/java/org/apache/ambari/server/configuration/ConfigurationTest.java > 074fbb4 > > ambari-server/src/test/java/org/apache/ambari/server/orm/InMemoryDefaultTestModule.java > 174d489 > > ambari-server/src/test/java/org/apache/ambari/server/state/cluster/ClustersTest.java > a1e2b48 > > Diff: https://reviews.apache.org/r/38487/diff/ > > > Testing > ------- > > Unit testing done. > [INFO] > ------------------------------------------------------------------------ > [INFO] BUILD SUCCESS > [INFO] > ------------------------------------------------------------------------ > [INFO] Total time: 01:31 h > [INFO] Finished at: 2015-09-17T17:21:55+00:00 > [INFO] Final Memory: 48M/605M > [INFO] > ------------------------------------------------------------------------ > > Functional testing: > Locally: done on Postgres & MySQL databases > > > Thanks, > > Oliver Szabo > >
