tonindexer / anton

Indexing for TON blockchain
https://anton.tools
Apache License 2.0
74 stars 16 forks source link

Offset for all 'root' methods #28

Closed sightorld closed 9 months ago

sightorld commented 10 months ago

Right now the only way to get to the batch with N offset in /accounts, /blocks, /messages and /transactions is to first load the N previous entities and get the last last_tx_lt, seq_no, created_lt and created_lt respectively, which heavilty restricts pagination and browsing overall

Would be good to add an offset field into all of those methods

iam047801 commented 9 months ago

We've decided not to implement this feature because a user-provided offset can be potentially very heavy for some Postgres queries.