API waiting time is long.

[FrederLu]

https://pudge.explorer.nervos.org/address/tb1qd5q7hs0q0px6qj55j2nkkhjgm2zep7765zjyhs?page=3

The api waits for a long time and the page cannot display data.

[rabbitz]

PR: nervosnetwork/ckb-explorer#2163

[FrederLu]

The api query has been optimized.
However, if the address query contains a lot of data, it will still be slow. For example there are 600+ data under the tb1qssu8pscsuevnmvhnr08840wvuzdan27k9m46ja address, the loading time will still be relatively long.

[poor-defined]

The api query has been optimized. However, if the address query contains a lot of data, it will still be slow. For example there are 600+ data under the tb1qssu8pscsuevnmvhnr08840wvuzdan27k9m46ja address, the loading time will still be relatively long.

Got it, mark it as Hold on

[rabbitz]

https://docs.aws.amazon.com/zh_cn/AmazonRDS/latest/UserGuide/wait-event.iobuffile.html

Increasing the work_mem parameter from 4MB to 200MB

[FrederLu]

https://docs.aws.amazon.com/zh_cn/AmazonRDS/latest/UserGuide/wait-event.iobuffile.html

Increasing the work_mem parameter from 4MB to 200MB

https://pudge.explorer.nervos.org/address/tb1qssu8pscsuevnmvhnr08840wvuzdan27k9m46ja

Before：

Now：

The same data has been significantly improved in API response after adjustment compared with the previous one. Verification passed.