ElementsProject / ElementsProject/lightning

Optimise SQL queries for giant nodes

Open
#8,783 0 comments 0 reactions 0 assignees View on GitHub
Highlight - UX and Dev Experience
Dominant language
C
Stars
3.1k
Forks
1k
Avg merge
4d 10h
Merged PRs (30d)
13

Description

Currently, some SQL queries are not performing efficiently for large nodes in the cln-application. While it would be ideal to optimise all SQL tables, the following tables are particularly important for the application's better performance:

- bkpr_accountevents
- invoices
- nodes
- offers
- peerchannels
- peers
- sendpays

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.