Optimise SQL queries for giant nodes #8783
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