I’ve submitted another pull request to Lucee 6 which re-works Lucee’s Query of Query support again-- this time using parallel Java streams to double the performance of QoQs up to 1 Million rows in size.
Check out this blog where I go over what changed, and showcase a large set of performance metrics comparing Lucee 5.3.10 to the Lucee 6 snapshots (with my patch applied). And scroll down to the bottom for some rather embarrassing graphs including Adobe ColdFusion