frontend/migrations/064_add_jobs_and_tests_time_indices.py - Issue 4823005: Merge remote branch 'cros/upstream' into tempbranch

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Keyboard Shortcuts

	File
u :	up to issue
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line

	Issue
u :	up to list of issues
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue

Side by Side Diff: frontend/migrations/064_add_jobs_and_tests_time_indices.py

Issue 4823005: Merge remote branch 'cros/upstream' into tempbranch (Closed) Base URL: http://git.chromium.org/git/autotest.git@master

Patch Set: Created 10 years, 1 month ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

OLD	NEW
(Empty)
	1 # These indices speed up date-range queries often used in making dashboards.

	2 UP_SQL = """

	3 alter table tko_tests add index started_time (started_time);

	4 alter table afe_jobs add index created_on (created_on);

	5 """

	6

	7 DOWN_SQL = """

	8 drop index started_time on tko_tests;

	9 drop index created_on on afe_jobs;

	10 """
	truty 2010/11/15 19:32:09 This will make our db bigger and this db upgrade w This will make our db bigger and this db upgrade will take some time. But, I don't think it will help us that much since we don't much do this kind of query.
OLD	NEW