How to reduce the load on the processor when accessing the database?

Question

Python

There is a bot, it launches 10 tasks (pages are parsed) through asyncio for 1 user, in each 1 task the database is accessed 4-5 times, this loads the processor very much and the bot starts to slow down, how can I reduce the load on the processor?

UPD There are many cores on my server, but for some reason not all of them are used. I


create a connection asyncpg.create_pool()

using

async with self.pool.acquire() as con:
            await con.execute(sql)

Answer 1

Do tasks on a separate thread using the Threading library
https://docs.python.org/3/library/threading.html

Answer 2

If the load on the database starts to slow down the rest - apparently (provided that the database is properly configured, the connection pool is enabled, requests are optimized, etc.), the time has come to distribute them to different containers / virtual machines.