Cache Refactor Tracking Issue

[Flouse]

This issue tracks the progress of refactoring the caching mechanism within the btc-assets-api. The goal is to improve performance by caching data。

• [x] rgbpp/v1/address/tb1q4vsuv95gdum3cdrswujv9qzqf72ehqxh7vhhak/activity

  curl 'https://btc-assets-api-git-fix-182-duplicated-bindings-cell-studio.vercel.app/rgbpp/v1/address/tb1q4vsuv95gdum3cdrswujv9qzqf72ehqxh7vhhak/activity?rgbpp_only=false'

  It is recommended to cache the data. It takes a long time to check the data now.

  • Originally posted by @Dawn-githup in https://github.com/ckb-cell/btc-assets-api/issues/194#issuecomment-2303664171

• [ ] Feel free to add new slow queries here @Dawn-githup

[Flouse]

• rgbpp/v1/address/tb1q4vsuv95gdum3cdrswujv9qzqf72ehqxh7vhhak/activity

curl --location --request GET 'https://api.testnet.rgbpp.io/rgbpp/v1/address/tb1q4vsuv95gdum3cdrswujv9qzqf72ehqxh7vhhak/activity' \
--header 'Authorization: ...' \
--header 'Origin: https://api.testnet.rgbpp.io' \
-w '\n* Response time: %{time_total}s\n'

• Response time: 2.835890s

[Dawn-githup]

I am validating on the testnet at "https://api.testnet.rgbpp.io/" with an average response time of about 2 s