ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/JSOC/proj/util/scripts/makelcindices.pl
Revision 1.3 - (view) (annotate) - [select for diffs]
Wed Jul 31 23:44:27 2013 UTC (10 years, 1 month ago) by arta
Branch: MAIN
CVS Tags: HEAD, Ver_8-1, Ver_8-10, Ver_8-11, Ver_8-12, Ver_8-2, Ver_8-3, Ver_8-4, Ver_8-5, Ver_8-6, Ver_8-7, Ver_8-8, Ver_9-0, Ver_9-1, Ver_9-2, Ver_9-3, Ver_9-4, Ver_9-41, Ver_9-5, Ver_LATEST
Changes since 1.2: +1 -1 lines
Diff to previous 1.2
Update the exe path for ActiveState updates.

Revision 1.2 - (view) (annotate) - [select for diffs]
Sun Apr 17 21:20:18 2011 UTC (12 years, 5 months ago) by arta
Branch: MAIN
CVS Tags: Ver_5-13, Ver_5-14, Ver_6-0, Ver_6-1, Ver_6-2, Ver_6-3, Ver_6-4, Ver_7-0, Ver_7-1, Ver_8-0
Changes since 1.1: +1 -0 lines
Diff to previous 1.1
When sorting by group for a single metric, print only one column of data (for the one metric)

Revision 1.1 - (view) (annotate) - [select for diffs]
Tue Mar 8 18:20:50 2011 UTC (12 years, 6 months ago) by arta
Branch: MAIN
This script adds lower-case indices to 4 drms_* tables. We have queries that run billions of times a day on these tables, and the queries were resulting in sequential scans through these tables. By adding these lower-case indices, and making a minor change to the queries, the queries do index scans, which run ~30 faster than the sequential scans.

Convenience Links

Links to HEAD: (view) (annotate) Links to Ver_8-10: (view) (annotate)

Compare Revisions

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, select a symbolic revision name using the selection box, or choose 'Use Text Field' and enter a numeric revision.

  Diffs between and
  Type of Diff should be a