Balance query is slower and slower

[wafeishushu]

LND Version: v0.21.4
DB: BoltDB

I’ve noticed that balance queries in LND are becoming increasingly slow.
As mentioned in the title, our node has been running for many years and uses BoltDB.
We’ve recently observed that the following API queries are taking a long time to complete:
/v1/balance/blockchain
/v1/channels/pending
These APIs seem to get slower over time as more data accumulates. Are there any ways to optimize this?