Jewellery Luck and Choice Mart · 2026
Report performance engineering
Cut a stock ledger report from 180 seconds to 5 and a stock card report from 20 minutes to under 90 seconds by moving work from Python loops into set-based SQL and fixing connection-pool exhaustion.
Role: Performance engineer
Odoo 17PostgreSQLReportingBIRT
180 s to 5 s
Stock ledger
1200 s to 88 s
Stock card
Highlights
- Profiled slow reports at the database level, found per-row queries and rewrote them as batched queries with the right indexes.
- Traced intermittent outages to SQL-view modules exhausting the connection pool, and fixed the configuration that caused it.
- Kept the business report engine and the original report layouts unchanged, so users saw only the speed-up.