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.

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

Power Point slide used in this video

• Using joins to merge the Orders and Order Details Controllers
• Merging the Orders and Customers Controllers with Joins
• Using Group By in an SQL Statement
• Using SQLGroupBy Class
• Merge the Display Data and Collect Data Controllers

---

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