3 ms·

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 9y ago
  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 9y ago
    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.