Happy President's Day!" "" "Last week, I mentioned...

Happy President's Day!" "" "Last week, I mentioned that I had bumped up the size of my DB for Sentitrac and would look deeper into whether my data architecture needed some tweaks. It turns out I had a specific data retrieval of league rosters that was not saving as expected and consumed 95% of my DB!" "" "After carefully double-checking this, I deleted these extraneous records and quickly got my DB usage from ~93 GB to ~5 GB. Just like that, I could actually go back to the original DB size I had been using, saving me a bit of cash in the process. " "" "While ideally, I would've caught this when my DB started growing at the rate it did, I'm making so many changes around the same time that it's not something that raised any major alarms until things started to break down when the DB reached its capacity. At that point, upgrading the size helped buy me time to investigate!" "" "Going forward, I'll definitely keep a closer eye on the overall size of my database, and try and more proactively get ahead of similar issues should they arise again.

---

Original post on LinkedIn