Re: FN-FORUM: MySQL query/table optimisation

date posted 23rd January 2007 18:26

On Tuesday 23 Jan 2007 4:47 pm, Ben Moxon wrote:

> It is indeed. Had I run that query I would have realised it, but I had
> discarded from the end of that the "LIMIT 1" thinking it made no
> difference. Oh boy was I wrong.

What else is in the ranges table? Do ranges overlap?