fix: pagination support for score

RSS3-Network / Global-Indexer

In the vast RSS3 Network, the Global Indexer navigates requests with precision, it is a beacon in the byte-filled sea.

MIT License

13 stars 0 forks source link

Closed brucexc closed 3 months ago

brucexc commented 3 months ago

Corrected pagination for nodes to handle identical scores, ensuring no duplicates or missed entries by using score and create_at time for consistent ordering.
Added an index on the score column to improve query performance.