[FEATURE] Replace `QueuePool` with `AsyncAdaptedQueuePool` - Githubissues

BoostryJP / ibet-Prime

Advanced API Toolkit for Digital Securities Issuance and Management on the ibet Network 🚀

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

Apache License 2.0

11 stars 1 forks source link

[FEATURE] Replace `QueuePool` with `AsyncAdaptedQueuePool` #602

Closed YoshihitoAso closed 7 months ago

YoshihitoAso commented 7 months ago

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

Same as https://github.com/BoostryJP/ibet-Wallet-API/issues/1490

It is recommended to use AsyncAdaptedQueuePool in asyncio with queue pool.

https://docs.sqlalchemy.org/en/20/core/pooling.html#sqlalchemy.pool.AsyncAdaptedQueuePool

If AsyncAdaptedQueuePool is not used, if the queue is stuck, it will be blocked and throughput will decrease.

Describe the solution you'd like

Use AsyncAdaptedQueuePool instead of QueuePool