ExecuteSQL needs Much Faster IN()

Idea created by Vincent_L on Feb 7, 2017
    Active
    Score10

    Hi,

    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

     

    Thanks

     

    P.S : Tested with 40K keys