79fb0cba806fd429dbd35caf21944d3e3b24a3d2
hiram
  Thu May 16 11:28:45 2019 -0700
note about index on Frames table no redmine

diff --git src/hg/makeDb/doc/dm6/multiz124way.txt src/hg/makeDb/doc/dm6/multiz124way.txt
index 5e8e6a6..e65f63b 100644
--- src/hg/makeDb/doc/dm6/multiz124way.txt
+++ src/hg/makeDb/doc/dm6/multiz124way.txt
@@ -2227,30 +2227,33 @@
 #   83559 droSec1
 
     # RBest:
 #   55003 dm6
 #  175910 droAna3
 #  114498 droEre2
 #  198449 droPer1
 #   89753 droSec1
 
     #   load the resulting file
     ssh hgwdev
     cd /hive/data/genomes/dm6/bed/multiz124way/frames
     time hgLoadMafFrames dm6 multiz124wayFrames multiz124wayFrames.bed.gz
     #   real    0m17.036s
 
+    # this table needs a better index for performanc:
+    hgsql dm6 -e 'CREATE INDEX src on multiz124wayFrames (src, bin);'
+
 
     hgsql -e 'select count(*) from multiz124wayFrames;' dm6
     # +----------+
     # | count(*) |
     # +----------+
     # |  3003403 |
     # +----------+
 
 
     time featureBits -countGaps dm6 multiz124wayFrames
     # 27774049 bases of 143726002 (19.324%) in intersection
     # real    0m14.701s
 
     #   enable the trackDb entries:
 # frames multiz124wayFrames