c8da620b1e51e27548201a8f4aa16bbc4d9aaecc
hiram
  Mon Jan 7 10:13:30 2019 -0800
add to comment about speed up display refs #19937

diff --git src/hg/hgTracks/wigMafTrack.c src/hg/hgTracks/wigMafTrack.c
index 4aded9c..0c1a1b4 100644
--- src/hg/hgTracks/wigMafTrack.c
+++ src/hg/hgTracks/wigMafTrack.c
@@ -2398,32 +2398,34 @@
        * NOTE: want to make sure that all sequences are soft-masked
        * if we do this */
     /* HAVE DONE:  David doesn't like lower case by default
      * TODO: casing based on quality values ?? */
     alignSeqToUpperN(line);
     if (complementBases)
         {
 	complement(line, strlen(line));
         }
     /* draw sequence letters for alignment */
     hvGfxSetClip(hvg, x, y-1, width, mi->height);
 
     /* having these static here will allow the option 'codonDefault'
      * to run rapidly through the display without extra calls to SQL
      * for the same answer over and over.  For other codon modes, it
-     * will still need to query the Frames table repeatedly.  Currently this
-     * is slow, perhaps it needs an index on the src column ?
+     * will still need to query the Frames table repeatedly.
+     * This was found to speed up dramatically by adding an index to
+     * the table:
+     * hgsql staAur2 -e 'CREATE INDEX src on multiz369wayFrames (src, bin);'
      */
     static char * extraPrevious = NULL;
     static struct mafFrames *mfList = NULL, *mf;
     static boolean found = FALSE;
     if (framesTable != NULL)
 	{
 	char extra[512];
 
 	if (sameString("codonDefault", codonTransMode))
 	    {
 	    safef(extra, sizeof(extra), "src='%s'",defaultCodonSpecies);
 
 	    found = TRUE;
 	    }
 	else if (sameString("codonFrameDef", codonTransMode))