where Clause Optimisation - Equals only
According to Jade Help the "where" Clause is only optimised for the following:
"In the forward direction, the expressions key > value or key >= value are optimized."
"In the reverse direction, the expressions key < value or key <= value are optimized."
We use this a lot for equals only so when doing a foreach we find our first line in the loop would be to check if the key is greater than what we are looking for and if so break out. If the foreach was optimised for equals then that would avoid the need for doing this.
HistoricalComments
FileVision UK Ltd 22/03/2018 2:43:11 AM Would it make sense to expand this to <> as well?
|