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.