Featured Work - Zumbiel Packaging

PROBLEM

Zumbiel's Inventory Status web report, part of their online Customer Service portal, was taking over five minutes to return data, maxing out the SQL Server in the process.

SOLUTION

We analyzed the existing SQL queries driving the report, and created new stored procedures designed to return data in a more efficient manner.

Under the hood, we updated the report from Classic ASP to ASP.NET 2.0, utilizing intrinsic .NET controls such as the GridView, and implementing AJAX callbacks for an improved user experience (AJAX callbacks allow web page data to be refreshed without reloading the entire page). We also added functionality for sorting data on all columns (along with sort arrow indicators), as well as totals for selected columns.

On the UI side, we added a custom tabbed interface to separate the main Inventory Status data from the WIP Jobs data, allowing each report to be viewed separately or all together.

RESULTS

The updated report now runs in less than 30 seconds with minimal load on the server. It looks great, offers a better user experience, and most of all, vastly improved performance.