Changeset 33182 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Jan 31, 2012, 9:52:33 AM (14 years ago)

Author:

rhenders

Message:

after purging detections, we now OPTIMIZE the detections table

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (1 diff)

trunk/ippToPsps/jython/scratchdb.py

@@ -447 +447 @@
                self.logger.errorPair("Unable to delete " + region + " from", self.dvoDoneTable)
 
-        
-        return detectionCount - self.getRowCount(self.dvoDetectionTable)
+        finalCount = detectionCount - self.getRowCount(self.dvoDetectionTable)
+
+        # after a big delete, we should OPTIMIZE the table
+        self.logger.infoPair("Running OPTIMIZE on ", self.dvoDetectionTable)
+        if finalCount > 0: self.optimizeTable(self.dvoDetectionTable)
+
+        return finalCount