5 ms·
for many cases, paginating by a timestamp range is meaningful, performant and deterministic. though you lose the ability to view a fixed number of rows which ca
by leeoniya 7y ago
for many cases, paginating by a timestamp range is meaningful, performant and deterministic. though you lose the ability to view a fixed number of rows which can result in some awkward ui...but i guess this is when overflow-y: scroll can work around that.
- yowlingcat 7y agoCertainly true, although that pain is something that can be at least partially mitigated in the backend. You can use approaches that are similar to exponential backoff, just with LIMIT, so that you do end up filling up your page. While there's some annoying bookkeeping involved, it does work and it does scale.