Sales Order Grid Performance

We don’t have a ton of performance updates this week, but that’s because we’ve been heads down on getting off of our old infrastructure and completely onto SQL. This means we can finally optimize the application for this new data structure, which is exciting.  A nice first step here is rewriting the sales order grid.

In an effort to improve data consistency, we've refactored the sales order grid so that all data, including shipping and invoicing statuses, are calculated on demand from primary data sources.  Previously, we maintained a "cache" for faster lookups, and despite the effort we would expend to try and keep it updated, it would still occasionally go out of sync with the source records.  This is no longer necessary in SQL-world, so in addition to the consistency improvement, we will also be able to drop all of the background updates that were responsible for trying to keep this “cache” up to date – meaning more horsepower for running the app.

More to come!