Using Basic and not so basic sql to Dramatically Improve Performance

In this set of videos we'll take a real case from one of our customers where we were able to improve a process that takes 5 minutes, into one second using the powers of SQL.

We use the internal visual studio sql editor - as explained in: Writing sqls from within Visual Studio

We'll start with an intro where we explain the controller's functionality which is the target of our performance improvement. We'll then explain basic SQL and move through the steps, through not so basic SQL, until we reach the target of our improvement.

To download the code of the Controller being tuned, Click Here

• the very basics of sql
• using left outer join
• Intro to innert select in sql
• Getting the year and month from Orders
• Using innert select to replace a reversed relation
• using round and is null
• using a select statement as the source for another select statement
• Using group by
• Creating a different column for each month
• Inserting data to a table based on a select statement
• Integrating the sql statement into the code

---

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