Looking to move long-term crypto holdings (BTC, ETH, SOL) into cold storage.
After Ledger's controversial 'Recover' firmware update and Trezor's open-source Safe 3/5 line, which device is currently considered the industry gold standard for self-custody?
Our posts and activity tables passed 5 million rows and SELECT COUNT(*) FROM posts WHERE community_id = ? is taking over 450ms. Indexes are present on community_id.
What is the recommended architecture to make count lookups sub-millisecond without killing database CPU?
