mirror of
https://github.com/luxfi/graph.git
synced 2026-09-24 00:26:07 +00:00
zeekayandHanzo Dev
7c5736ac42
GetSwaps compares pool COLLATE NOCASE and orders by timestamp. SQLite consults an index only when its collation matches the comparison's, so idx_swaps_pool — built BINARY — was never used for that read: one quiet pool's last trades was a scan of every swap on the chain, seconds per pool, and a token page asks once per pool it trades in. Seventeen pools took forty seconds through the exchange-api and timed out on the way. The index now names the collation and carries the timestamp, so the read is a range on the index in the order it is asked for. The old one is dropped on Init, so a store that already built it stops carrying it. Co-authored-by: Hanzo Dev <[email protected]>