>>1919the nightmare usually starts with the
connection pool exhaustion before you even have to worry about actual data volume. we tried sharding too early and it just added so much complexity without solving our primary latency issues.
>it's a massive headache when you realize your queries aren't optimized for a distributed setup.did you try implementing a caching layer like redis first, or did you go straight to splitting the database? ❓ lol