Export a Report Through One Cursor
Separate all-rows XLSX export from page queries: consume one result cursor, preserve permissions and cell conversion, stage the file, and verify failure cleanup.
TAGTags
performance
5 articles
Budgeting the Real First-Load Dependency Graph of a Vite SPA
A Vite manifest can turn an SPA's real first-load dependency closure into a gzip budget, catching regressions that total build size and single-chunk checks miss.
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.
When a Production Dashboard Shows Zero Despite Having Data
Replacing full-detail loading with database aggregation after a production dashboard timed out and left every counter at its initial zero.
Optimizing a Slow MySQL Wave List Query: From Index Tests to a SQL Rewrite
How I investigated a slow WMS list query, reverted ineffective index attempts, and validated a much faster query structure.