Hacker News new | ask | show | jobs
by sk5t 1969 days ago
Did you consider lowering those IOPS with application-level and/or distributed in-memory cache and/or pub-sub notifications to let your app nodes not pester the database so much? Reasonably performant hand-written SQL (no ORM!), review of query plans, maybe shift the hot path into functions/procs?
1 comments

Believe it or not these numbers are actually from _after_ me and some others spent a few weeks cleaning up our heavier queries