Version 2.4.1 is fully multithreaded and supports high performance 2PL and MVCC (multiversion concurrency control) transaction control models. http://hsqldb.org/
I always thought one of the reasons QofQ was slow is it gets single threaded under HSQLDB 1.8.0. Would upgrading to use 2.4.1 give us access to multithreaded support?
Is it worth upgrading the HSQLDB engine Lucee uses for this feature? Or are we better off to keep coding it out of existence?
To be honest i thought we’d already upgraded? Or is this just a reference to the embedded database and JDBC driver that is available?
I’d also be interested in what improvements could be made to QoQ to speed things up. We are stuck with it for A LOT of work as one of our main functions is using Lucee as middleware to connect disparate systems that use several different db’s as back ends (e.g. MySQL, FoxPro, Oracle, etc.)
The only way I know of joining resultsets is through QoQ.