Rod Dutton wrote:
> I also should add that the sp is only slow when the table is big (probably
> obvious!).
>
> Rod
Sure, the problem is it is switching to a sequential search, with a lot
of rows, versus doing an indexed search.
It's all about trying to figure out how to fix that, especially for any
value of botnum. I would have hoped that using LIMIT 1 would have fixed
that.
John
=:->
