Seriously, WTF?

David Cantrell david at
Thu May 8 14:12:11 BST 2008

On Thu, May 08, 2008 at 02:05:32PM +0100, Christopher Jones wrote:

> I have a relatively simple table with approximately 100 million rows  
> of data, and query times suck. I'd be interested to know whether  
> anyone thinks this is good, acceptable/normal, or bad;
> mysql> select * from histones where chr='1' and location > 10000 and  
> location < 20000;
> ...
> 7 rows in set (3 min 39.94 sec)

Do you have indices on the chr and location fields?

David Cantrell | Hero of the Information Age

  I remember when computers were frustrating because they did
  exactly what you told them to.  That seems kinda quaint now.
      -- JD Baldwin, in the Monastery

More information about the mailing list