How to rank grouped results in SQL without unexpected partitions?

Question

Asked53 days ago

Viewed205 times

I'm working on **SQL** and need to rank grouped results. I've tried a simple cache layer, but I'm still seeing unexpected partitions. Context: - Dataset size: small startup - Expected output: p95 < 200ms - Current behavior: timeouts under load What would be a clean approach here, and what should I watch out for?

sql analytics

asked 53 days ago

Rahul Gupta1810

0 Answers

🚀

Be the first to help!

No answers yet 😶 Share your approach, ask a follow-up clarification, or add a code snippet to help out.