3 ms·

But what if a message gets deleted from middle of the list? This happens with forum messages.

• ngrilly 9y ago
  You keep it and mark it "deleted", and you show "deleted" in place of the message. This is what most forums do already, independently of the underlying pagination mechanism.
  • thriftwy 9y ago
    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.