Re: FN-FORUM: MySQL query/table optimisation

date posted 23rd January 2007 15:50

On 23 Jan 2007 13:15:14 -0000, Ben Moxon [EMAIL REMOVED] wrote:
>
> 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