JADE Environment Development Ideas

What's new in the upcoming JADE release?

IMPROVED DEVELOPER EFFICIENCY. ENHANCED SECURITY. SMOOTHER INTEGRATION

The JADE 2022 release meets tomorrow’s business demands.


Start your update to JADE's latest release

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.
  • Guest
  • May 1 2019
  • Future consideration
HistoricalComments
FileVision UK Ltd 22/03/2018 2:43:11 AM
Would it make sense to expand this to <> as well?
  • Attach files
  • +4