Projects
Zhijie handled the Cash Movement Report release to VIP customers last Friday while I was out. Today I noticed one customer with a slow query time of 42 seconds in the logs. I analyzed their query in the BigQuery console and found they have many orphaned records, specifically cash movements without corresponding register open sequences. These may have been deleted at some point.
After discussing with Zhijie and Dania, we created a megabranch to merge all of our Sales History changes into while the code freeze is in effect. This long-lived feature branch lets us keep integrating work without touching main. We struggled with some CI issues, and it looks like many other teams have been hitting similar problems recently.
Investigations
The 42-second query for that one Cash Movement Report customer warrants further investigation. The orphaned records are inflating query time significantly, and we may need to add filtering logic or a cleanup job to handle these edge cases.