Experimental optimization for truncate on Oracle

WilliamRen · Jan 15, 2015 · 1899835 · 1899835
1 parent feaf31f
commit 1899835
Showing 1 changed file with 10 additions and 1 deletion.
diff --git a/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java b/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java
@@ -63,6 +63,10 @@ public final IDataTypeFactory getDbUnitFactory() {
 
   abstract List<String> resetPrimaryKey(String table, int minSequenceValue);
 
+  String getTruncateCommand(String table) {
+    return "TRUNCATE TABLE " + table;
+  }
+
   public static DatabaseCommands forDialect(Dialect dialect) {
     DatabaseCommands command = ImmutableMap.of(
       org.sonar.core.persistence.dialect.H2.ID, H2,
@@ -96,6 +100,11 @@ List<String> resetPrimaryKey(String table, int minSequenceValue) {
         "DROP SEQUENCE " + sequence,
         "CREATE SEQUENCE " + sequence + " INCREMENT BY 1 MINVALUE 1 START WITH " + minSequenceValue);
     }
+
+    @Override
+    String getTruncateCommand(String table) {
+      return "TRUNCATE TABLE " + table + " REUSE STORAGE";
+    }
   };
 
   private static final DatabaseCommands MSSQL = new DatabaseCommands(new MsSqlDataTypeFactory()) {
@@ -128,7 +137,7 @@ public void truncateDatabase(DataSource dataSource) throws SQLException {
       statement = connection.createStatement();
       for (String table : DatabaseVersion.TABLES) {
         try {
-          statement.executeUpdate("TRUNCATE TABLE " + table);
+          statement.executeUpdate(getTruncateCommand(table));
           connection.commit();
         } catch (Exception e) {
           // ignore