[FEATURE] Performance: API for chain block data - 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] Performance: API for chain block data #1340

Closed purplesmoke05 closed 1 year ago

purplesmoke05 commented 1 year ago

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

In current implementation, if there are over million number of blocks the following API takes long time because of their SELECT COUNT(1) query.
- GET: /Nodeinfo/BlockData
https://github.com/BoostryJP/ibet-Wallet-API/blob/c3cf6e6fef67c07dafdeee73624e4e9860729d96/app/api/routers/bc_explorer.py#L99-L100
With 30 million blocks, it can take up to 50 seconds for this API to return a response.

Describe the solution you'd like

Modify the logic of getting total count of block data list.