So basically I'm pretty sure now that we need a new kind of SQL INDEX, as in, pa... | Hacker News

Hacker Timesnew | past | comments | ask | show | jobs | submit

thriftwy on Oct 16, 2017 | parent | context | favorite | on: Efficient pagination of a SQL table with 100M reco...

So basically I'm pretty sure now that we need a new kind of SQL INDEX, as in, pagination index.

To do that aforedescribed accounting for us, and more.

ngrilly on Oct 17, 2017 [–]

It wont't be a new kind of index. It would be a new interpretation of OFFSET and LIMIT, which would ignore deleted rows.

thriftwy on Oct 17, 2017 | [–]

Why would it? It will be rebuilt when a row is deleted or even marked deleted.

If we have an pagination index over (topicId, deleted) on postTime asc.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact