Improvement in IN LIST queries - Oracle
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.
Improvement IN LIST queries - MySQL
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.
IN LIST queries - improve insertion speed
Improvement is especially noticeable while connection to database is over VPN.
Derby driver has been updated to the latest version
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.