Re: [sqlalchemy] Speed performance

2022-12-09 Thread Jaime Valdez
nc.gather(), each task should receive (or create on its own) a > separate AsyncSession that's independent of the other, and each > AsyncSession should proceed on its own connection/transaction. You can't > do concurrent work within a single transaction even with an asyncpg > conne

[sqlalchemy] Speed performance

2022-12-07 Thread Jaime Valdez
Hi group, I'm having some issues trying to do some queries using the create_async_engine, the following code is the fastest one. import time import asyncio from typing import Any, Dict, List from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from sqlalchemy import