ExecuteSQL is immensely useful, but it's speed is lacking. It needs a big boost in many of it's functions.
But, one is particularly slow and is use a lot, that's the IN statement that's used to pass a lot of keys.
It's orders of magnitude slower than a Go to related record from a global. This shouldn't be.
As it's a statement that's very common it as to be made much faster
P.S : Tested with 40K keys