A wave planning list in a WMS application took about six seconds to return one page of results. This note records the investigation path and the evidence behind the final optimization direction.

Identifiers and environment details have been anonymized. The SQL shape, measurements, and decisions are …

Recently I spent a lot of time fixing small but important bugs in logistics systems. Most of them were not difficult because of one single line of code. They were difficult because the same page, status, interface, and database field were used by several business steps.

This post records several …