On Thu, 2010-09-30 at 12:54 -0700, Gregory Smith wrote: > 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.
Applied, thanks! > 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 _______________________________________________ Autotest mailing list [email protected] http://test.kernel.org/cgi-bin/mailman/listinfo/autotest
