Changeset 61183 in vbox for trunk/src/VBox

Timestamp:

May 25, 2016 12:17:34 AM (9 years ago)

Author:

vboxsync

Message:

partial-db-dump.py: perf hack

File:

• trunk/src/VBox/ValidationKit/testmanager/db/partial-db-dump.py (modified) (1 diff)

trunk/src/VBox/ValidationKit/testmanager/db/partial-db-dump.py

@@ -171 +171 @@
             oDb.execute('COPY (SELECT it.*\n'
                         '      FROM ' + sTable + ' it, TestResults tr\n'
-                        '      WHERE  tr.idTestSet >= %s AND it.idTestResult = tr.idTestResult )\n'
-                        '  TO %s WITH (FORMAT TEXT)',
-                        (idFirstTestSet, sFile,));
+                        '      WHERE  tr.idTestSet >= %s\n'
+                        '         AND tr.tsCreated >= %s\n' # performance hack.
+                        '         AND it.idTestResult = tr.idTestResult\n'
+                        ') TO %s WITH (FORMAT TEXT)',
+                        (idFirstTestSet, tsEffective, sFile,));
             cRows = oDb.getRowCount();
             print '... %s rows.' % (cRows,);