Add indices on the tko_tests.start_time and afe_jobs.created_on columns. We query on these to process data for generating custom dashboards.
Signed-off-by: Gregory Smith <[email protected]> --- /dev/null 2009-12-17 12:29:38.000000000 -0800 +++ autotest/frontend/migrations/064_add_jobs_and_tests_time_indices.py 2010-09-30 12:39:33.000000000 -0700 @@ -0,0 +1,10 @@ +# These indices speed up date-range queries often used in making dashboards. +UP_SQL = """ +alter table tko_tests add index started_time (started_time); +alter table afe_jobs add index created_on (created_on); +""" + +DOWN_SQL = """ +drop index started_time on tko_tests; +drop index created_on on afe_jobs; +""" _______________________________________________ Autotest mailing list [email protected] http://test.kernel.org/cgi-bin/mailman/listinfo/autotest
