I also should add that the sp is only slow when the table is big (probably obvious!).
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.
Description: OpenPGP digital signature