8f8d2c5198b159354cb73c5820b15048d5d07654
angie
  Fri Apr 6 10:00:15 2012 -0700
Switching from sqlStoreResult back to sqlGetResult -- it's faster forgiant queries e.g. on snp135.  For #6152

diff --git src/hg/lib/annoStreamDb.c src/hg/lib/annoStreamDb.c
index f225dc2..052aa09 100644
--- src/hg/lib/annoStreamDb.c
+++ src/hg/lib/annoStreamDb.c
@@ -40,31 +40,31 @@
 struct dyString *query = dyStringCreate("select * from %s", self->table);
 if (!streamer->positionIsGenome)
     {
     dyStringPrintf(query, " where %s='%s'", self->chromField, streamer->chrom);
     int chromSize = hashIntVal(streamer->query->chromSizes, streamer->chrom);
     if (streamer->regionStart != 0 || streamer->regionEnd != chromSize)
 	{
 	dyStringAppend(query, " and ");
 	if (self->hasBin)
 	    hAddBinToQuery(streamer->regionStart, streamer->regionEnd, query);
 	dyStringPrintf(query, "%s < %u and %s > %u", self->startField, streamer->regionEnd,
 		       self->endField, streamer->regionStart);
 	}
     }
 verbose(2, "mysql query: '%s'\n", query->string);
-struct sqlResult *sr = sqlStoreResult(self->conn, query->string);
+struct sqlResult *sr = sqlGetResult(self->conn, query->string);
 dyStringFree(&query);
 self->sr = sr;
 }
 
 static char **nextRowUnfiltered(struct annoStreamDb *self)
 /* Fetch the next row from the sqlResult, and skip past table's bin field if necessary. */
 {
 char **row = sqlNextRow(self->sr);
 if (row == NULL)
     return NULL;
 // Skip table's bin field if not in autoSql:
 row += self->omitBin;
 return row;
 }