Trouble in The Old Republic
summary
Finds a real bug: a search by planet is slow because the app issues a SELECT and pulls JSON into the client then filters locally, not the DB. The tale names Oracle and a plan to replace it with MongoDB, cites a 42‑page change form and an eight‑month upgrade window, and reports clients validating 40,000 sessions every 10 minutes* until the cleanup logic is moved back into the database. Proposes two concrete fixes: use modern SQL/JSON transformations or treat the DB as a versioned part of the app with automated migrations and tests.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 3:13Welcome to Galactic Enterprise
- 8:02New tester role
- 16:46Performance issues in Species App
- 17:07Technical troubles root causes
- 20:02Modern SQL knowledge gap
- 26:13Team trust issues
- 30:07Solving performance problems
- 31:55Change control risks
- 36:58Tooling gaps and skills
- 39:49Testers as collaborators
- 44:13Myth of Unicorn Land
- 45:43Reality over perfection
- 52:03Q&A
related talks
51mQ&A Session
54mTesting in Legacy: From Rags to Riches
50mAdam Furmanek: You Must Test Your Databases And Here Is How
36mBreaking Bug
28mTesting Isn't Enough: Fighting Bugs with Hacks
36mSQLancer: Automatically Finding Bugs in Database Management Systems
35m82 Bugs I Collected in a Year You Won’t Believe Made It to Production
26mThe software bug all stars - and what we can learn from them