Filter Before You Rank and Aggregate: Taking a 27-Second Query Down to About One Second
How moving selective business filters ahead of window functions and dependent aggregates cut a paginated Oracle query from 27.49 seconds to about 1.40 seconds.
LOGBlog
Engineering Notes
Database-backed investigations, migration lessons, production recovery, and practical AI-assisted engineering.
Page 4 / 7
Hibernating a Cloud Deployment to Zero Paid Resources Without Losing Recovery Proof
A recovery-first procedure for stopping a cloud workload, releasing every paid resource, and preserving evidence that the system can be restored.
A Business Sentinel Is Not Empty Data
A valid sentinel was converted to an empty string, breaking display, required-field validation, and request propagation until normalization was narrowed to true empty values.
Safe Edge-Worker Fallbacks for Missing Runtime Bindings
An edge deployment where basic HTTP checks passed but browser navigation returned 500 until optional cache and image capabilities gained tested fallback behavior.
Fixing Incorrect Direct Access with a Domain-Specific Proxy Rule
A local connectivity incident resolved by proving the remote service was healthy, isolating incorrect direct routing, and adding one precise proxy rule.
Verifying Cross-Module Business Flows with Database Reconciliation
An end-to-end logistics-platform acceptance run using real services, controlled test data, state history, and database reconciliation.