Databases & data modellingMediumSDE-1

Your admin panel lists transactions with LIMIT 50 OFFSET n. Page 1 is fast, but page 10,000 takes 8 seconds. Why, and what is the fix?

Asked at

PaytmRazorpayStripe

Think first

Answer out loud as you would in the room — clarify, give numbers, name the trade-off — then compare with the model answer.

Go deeper

Saved on this device. Create a free account to keep it on every device.

Practise this with Sam

A real mock interview, out loud, with an honest scorecard. Free to start.