[FEATURE] Reduce the number of DB load on batch `indexer_CompanyList` - Githubissues

BoostryJP / ibet-Wallet-API

A powerful API suite for seamlessly building ibet blockchain wallet systems 🛠

https://ibet.jp/ibet-for-fin

Apache License 2.0

9 stars 0 forks source link

[FEATURE] Reduce the number of DB load on batch `indexer_CompanyList` #1477

Closed purplesmoke05 closed 9 months ago

purplesmoke05 commented 9 months ago

Is your feature request related to a problem? Please describe.

Currently, in the indexer_CompanyList batch process, SELECT query is issued for each obtained CompanyList using session.merge().
As the number of CompanyList increases, this results in a large number of queries being sent to the database, leading to high load.
It is preferable to reduce the number of these queries.

Describe the solution you'd like

Reduce the number of DB loads on batch indexer_CompanyList not to call SQL if there are no difference between ComapnyList json fetched in current cycle and one fetched in before cycle.