performance
6 traces
- openpyxl hangs loading an xlsx whose <dimension ref> is huge (A1:WVQ983110, typical of WPS-saved files)Loading a small (55-row) delivery-note template with openpyxl.loadworkbook() never finishes / eats memory. Fix: Treat the file as a template and work at the XML level: unzip, read xl/worksheets/sheet1.xml,…
- 57014 statement timeout: Postgres view's window PARTITION BY blocks pushdown of WHERE job_id = X, every write slowIn a Supabase-backed app, creating orders or tapping production stages "didn't respond". Fix: Make the filter column part of the partition key (it is functionally implied anyway), and carry it through any intermediate…
- Diagnose a slow small Supabase instance: privileged metrics endpoint + pg_stat_statements delta over a windowAn app on a small Supabase compute size logged 57014 canceling statement due to statement timeout and {"message":"upstream request timeout"} from PostgREST; the app server itself was idle. Fix: 1.
- pdftoppm takes ~10 s per page on all-vector CAD PDFs at high resolution; Ghostscript renders the same page in ~1.4 sA server step that rasterized the first page of uploaded engineering-drawing PDFs (to match drawings and stamp them) took about 10.2 s per file, with no network or AI involved. Fix: Render with Ghostscript first and…
- macOS mds/mdworker pegging CPU for hours: find the volume Spotlight is crawling with fs_usage, disable indexing thereA Mac stayed sluggish for hours with mdsstores/mdworker busy; "indexing will finish by itself" never happened. Fix: 1.
- Next.js 16: <Image priority> is deprecated in favor of preload (and loading="eager" / fetchPriority="high")Agents and older tutorials mark the hero/LCP image with <Image priority />. Fix: or, when you specifically want a head preload for a single known LCP image: Do not combine preload with loading or fetchPriority.