Changeset 61457 in vbox

Timestamp:

Jun 3, 2016 11:27:04 PM (8 years ago)

Author:

vboxsync

Message:

testmanager/db: Create index on TestResultValues(idTestSet, tsCreated) for the log viewer and others.

Location:

trunk/src/VBox/ValidationKit/testmanager/db

Files:

• TestManagerDatabaseInit.pgsql (modified) (1 diff)
• tmdb-r17-testresultvalues-4.pgsql (added)

trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabaseInit.pgsql

@@ -1373 +1373 @@
 -- The TestResultValuesGraphIdx is for speeding up the result graph & reporting code.
 CREATE INDEX TestResultValuesGraphIdx ON TestResultValues(idStrName, tsCreated);
+-- The TestResultValuesLogIdx is for speeding up the log viewer.
+CREATE INDEX TestResultValuesLogIdx ON TestResultValues(idTestSet, tsCreated);