Changeset 35083

Timestamp:

Feb 2, 2013, 8:40:15 AM (13 years ago)

Author:

eugene

Message:

call analyze table after dvo detections are ingested to set up indexes

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py (modified) (1 diff)

branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py

@@ -634 +634 @@
         self.ippToPspsDb.setIngestedBox(boxId)
 
+        # add fileID column
+        sql = "ANALYZE TABLE " + self.scratchDb.dvoDetectionTable
+        try: self.scratchDb.execute(sql)
+        except: 
+            self.logger.errorPair("Unable to analyze mysql table", self.scratchDb.dvoDetectionTable)
+            return False
+
         # update lists after attempted sync
         # self.printSummary()