david at cantrell.org.uk
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 london.pm