Until now IN LIST queries had multiple limitations
the query is to long
oracle 64k limitation for IN
could be slow
Since version 17.20.0 there is improved performance on Oracle for in-list queries for lists based on integer, rowid or text (up to 4000 chars) fields and with more than 2000 items.
Improved performance on MySQL for in-list queries for lists based on integer or text (up to 4000 chars) fields and with more than 5000 items.
Improvement is especially noticeable while connection to database is over VPN.
Derby driver was updated to a new version 10.13.1.1. All Derby based projects will ask for update during schema open. This update does NOT allow to revert back to the older version of InstantJChem or Plexus Connect.