From: <sc...@hy...> - 2008-12-15 22:30:13
|
Author: scottmf Date: 2008-12-15 14:30:04 -0800 (Mon, 15 Dec 2008) New Revision: 12047 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=12047 Modified: trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java Log: [HHQ-2695] (reviewed by kashyap) added APPEND hint to Oracle PLSQL update on exception stmt. Saw at least a 30% throughput increase on HQ perf stack Modified: trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java =================================================================== --- trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java 2008-12-15 22:09:41 UTC (rev 12046) +++ trunk/src/org/hyperic/hq/measurement/server/session/DataManagerEJBImpl.java 2008-12-15 22:30:04 UTC (rev 12047) @@ -744,7 +744,7 @@ final boolean supportsPLSQL = dialect.supportsPLSQL(); final String plSQL = "BEGIN " + - "INSERT INTO :table (measurement_id, timestamp, value) " + + "INSERT /*+ APPEND */ INTO :table (measurement_id, timestamp, value) " + "VALUES(?, ?, ?); " + "EXCEPTION WHEN DUP_VAL_ON_INDEX THEN " + "UPDATE :table SET VALUE = ? " + |