FN-FORUM: MySQL query/table optimisation

date posted 23rd January 2007 12:24

I've got a mysql query that is taking 23 seconds to run the first time I call it, and about seven seconds subsequently. This appears to be the case regardless of whether I include an SQL_NO_CACHE hint in the query itself.

The query is finding the range to which a number belongs to, between two unsigned ints so currently I'm using "SELECT * FROM ranges WHERE ( start