Reducing Inner Controller tree to Improve Performance

In this set of videos we take a deep inner controller tree and improve it's performance using joins and group by.

2017 08 07 18H08 25

The scenario we've tested, which had 250,000 was taking one minute when we started.

Improving it with joins, reduced the time to 15 seconds.

Improving that with Group By reduced the time to 1/2 a second.

Here's the code of the controller before we optimize it. ProductSalesInfo.zip

---

the profiler we used in this process

2017 08 07 18H09 16

Power Point slide used in this video


Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com