A Small Schema Mistake That Slowed Down My Chat System (And How I Fixed It)

While developing my chat backend, I initially made a design decision that seemed ideal untill it didn't. As the system scaled, it led to significant performance issues. It wasn’t a complex bug.It was