cosmostation / mintscan-binance-dex-backend

:construction: Mintscan Backend for Binance DEX
https://binance.mintscan.io
Other
23 stars 32 forks source link

Performance Issue when counting all txs saved in DB #6

Closed jaybxyz closed 4 years ago

jaybxyz commented 4 years ago

Issue

There is performance Issue when counting all transactions which are saved in database. As there will be more transactions to count as time goes, this problem needs to be solved.

Possible solution

  1. Create a cron job that counts transactions and save it in other table.
jaybxyz commented 4 years ago

Use the latest index id in transaction table