New Features in IJC Q3 2017

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.