GitLab Mirror pushed to branch trunk at cms-community / hippo-jackrabbit
Commits: 0b91314f by Claus Köll at 2018-01-09T12:12:00+00:00 Debug Log git-svn-id: https://svn.apache.org/repos/asf/jackrabbit/trunk@1820647 13f79535-47bb-0310-9956-ffa450edef68 - - - - - 56b161f9 by Claus Köll at 2018-01-09T12:12:44+00:00 Debug Log git-svn-id: https://svn.apache.org/repos/asf/jackrabbit/trunk@1820649 13f79535-47bb-0310-9956-ffa450edef68 - - - - - 2 changed files: - jackrabbit-data/src/main/java/org/apache/jackrabbit/core/data/db/DbDataStore.java - jackrabbit-data/src/main/java/org/apache/jackrabbit/core/util/db/ConnectionHelper.java Changes: ===================================== jackrabbit-data/src/main/java/org/apache/jackrabbit/core/data/db/DbDataStore.java ===================================== --- a/jackrabbit-data/src/main/java/org/apache/jackrabbit/core/data/db/DbDataStore.java +++ b/jackrabbit-data/src/main/java/org/apache/jackrabbit/core/data/db/DbDataStore.java @@ -510,6 +510,7 @@ public class DbDataStore extends AbstractDataStore updateLastModifiedDate(key, 0); } // DELETE FROM DATASTORE WHERE LAST_MODIFIED<? + log.debug(deleteOlderSQL + " - Scanstart [" + min + "]"); return conHelper.update(deleteOlderSQL, min); } catch (Exception e) { throw convert("Can not delete records", e); ===================================== jackrabbit-data/src/main/java/org/apache/jackrabbit/core/util/db/ConnectionHelper.java ===================================== --- a/jackrabbit-data/src/main/java/org/apache/jackrabbit/core/util/db/ConnectionHelper.java +++ b/jackrabbit-data/src/main/java/org/apache/jackrabbit/core/util/db/ConnectionHelper.java @@ -301,6 +301,7 @@ public class ConnectionHelper { Connection con = null; Statement stmt = null; boolean inBatchMode = inBatchMode(); + long start = System.currentTimeMillis(); try { con = getConnection(inBatchMode); if (params == null || params.length == 0) { @@ -313,6 +314,8 @@ public class ConnectionHelper { } } finally { closeResources(con, stmt, null, inBatchMode); + long duration = System.currentTimeMillis() - start; + log.debug("SQL-Execution [{}] took [{}] ms.", sql, duration); } } @@ -339,12 +342,14 @@ public class ConnectionHelper { Connection con = null; PreparedStatement stmt = null; boolean inBatchMode = inBatchMode(); + long start = System.currentTimeMillis(); try { con = getConnection(inBatchMode); stmt = con.prepareStatement(sql); return execute(stmt, params).getUpdateCount(); } finally { closeResources(con, stmt, null, inBatchMode); + log.debug("SQL-Execution [{}] took [{}] ms.", sql, (System.currentTimeMillis() - start) ); } } @@ -389,6 +394,7 @@ public class ConnectionHelper { PreparedStatement stmt = null; ResultSet rs = null; boolean inBatchMode = inBatchMode(); + long start = System.currentTimeMillis(); try { con = getConnection(inBatchMode); if (returnGeneratedKeys) { @@ -421,6 +427,8 @@ public class ConnectionHelper { } catch (SQLException e) { closeResources(con, stmt, rs, inBatchMode); throw e; + } finally { + log.debug("SQL-Execution [{}] took [{}] ms.", sql, (System.currentTimeMillis() - start) ); } } View it on GitLab: https://code.onehippo.org/cms-community/hippo-jackrabbit/compare/9a51355ea57dca39afd6b891d93aa4dc500fd47c...56b161f9b14fde06e4fb6055d64681f20baff586 --- View it on GitLab: https://code.onehippo.org/cms-community/hippo-jackrabbit/compare/9a51355ea57dca39afd6b891d93aa4dc500fd47c...56b161f9b14fde06e4fb6055d64681f20baff586 You're receiving this email because of your account on code.onehippo.org.
_______________________________________________ Hippocms-svn mailing list Hippocms-svn@lists.onehippo.org https://lists.onehippo.org/mailman/listinfo/hippocms-svn
