# Improving Lucee's QoQ Support Again- now 200% faster

**URL:** <https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597>\
**Category:** dev\
**Tags:** qoq\
**Created:** [December 1, 2022, 11:17pm UTC](https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597 "2022-12-01T23:17:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bdw429s](https://dev.lucee.org/user_avatar/dev.lucee.org/bdw429s/32/37_2.png) [@bdw429s](https://dev.lucee.org/u/bdw429s)\
**Post date:** [December 1, 2022, 11:17pm UTC](https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597/1 "2022-12-01T23:17:09Z")

</div>

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 😕

> **[Improving Lucee's QoQ Support Again- now 200% faster](https://www.codersrevolution.com/blog/improving-lucees-qoq-support-again-now-200-faster)**
>
> Update 1/27/2023 - the pull has now been merged into the snapshot builds of Lucee 6! Two years ago, I published th

 ![image](https://dev.lucee.org/uploads/default/original/2X/8/825e6ba2f236fb30af76f9a04ef24ece66ab69e3.png)

---

<div class="post-metadata">

**Author:** ![Zackster](https://dev.lucee.org/user_avatar/dev.lucee.org/zackster/32/3484_2.png) [@Zackster](https://dev.lucee.org/u/Zackster)\
**Post date:** [January 27, 2023, 12:27pm UTC](https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597/2 "2023-01-27T12:27:44Z")

</div>

merged into 6.0.0.336, thanks @bdw429s

> <https://github.com/lucee/Lucee/commit/423fd0093c2fb44c7a5ab9990b996c7c6301d2c5>

---

<div class="post-metadata">

**Author:** ![Gavin\_Baumanis](https://dev.lucee.org/user_avatar/dev.lucee.org/gavin_baumanis/32/267_2.png) [@Gavin\_Baumanis](https://dev.lucee.org/u/Gavin_Baumanis)\
**Post date:** [January 27, 2023, 2:20pm UTC](https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597/3 "2023-01-27T14:20:03Z")

</div>

Awesome work Brad!

---

<div class="post-metadata">

**Author:** ![Jay.MC](https://dev.lucee.org/letter_avatar_proxy/v4/letter/j/a3d4f5/32.png) [@Jay.MC](https://dev.lucee.org/u/Jay.MC)\
**Post date:** [February 12, 2023, 9:09pm UTC](https://dev.lucee.org/t/improving-lucees-qoq-support-again-now-200-faster/11597/4 "2023-02-12T21:09:47Z")

</div>

Absolutely SWEET!!!  
That’s a **Sick Gain** in speed…!!
