ziggie
969b00e4a5
paymentsdb: implement FetchInFlightPayments for sql backend
2026-02-25 08:02:16 +01:00
ziggie
e8fe45fe65
paymentsdb: implement QueryPayments for sql backend
2026-02-25 08:02:08 +01:00
Elle Mouton
352b4d620a
graph/db: freeze sql migration queries
2025-11-12 22:54:06 +08:00
Elle Mouton
8de33fa601
graph/db: batch fetching for FetchChanInfos
2025-08-07 08:12:40 +02:00
Elle Mouton
594c842aeb
graph/db: batch loading for DisconnectBlockAtHeight
2025-08-07 08:12:40 +02:00
Elle Mouton
69bcf47dca
graph/db: use batch loading for PruneGraph
2025-08-07 08:12:40 +02:00
Elle Mouton
556af8e221
graph/db: use batch fetching for DeleteChannelEdges
2025-08-07 08:12:40 +02:00
Elle Mouton
ebe6a8af9f
graph/db: use batch loading for ChanUpdatesInHorizon
...
The following performance gains were measured using the new benchmark
test.
```
name old time/op new time/op delta
ChanUpdatesInHorizon-native-sqlite-10 18.5s ± 3% 2.0s ± 5% -89.11% (p=0.000 n=9+9)
ChanUpdatesInHorizon-native-postgres-10 59.0s ± 3% 0.8s ±10% -98.65% (p=0.000 n=10+9)
```
2025-08-07 08:12:40 +02:00
Elle Mouton
5afd9a5678
scripts: add sql slices workaround to sqlc gen script
...
This copies the workaround introduced in the taproot-assets code base
and will allow us to use `WHERE x in <list>` type queries.
2025-07-22 17:14:55 +02:00
ziggie