In my personal opinion, this isn't an issue with TypeORM itself, but rather with the database design. You need to identify the bottleneck first. Perhaps you could try optimizing your queries initially. Typically, you'd start by checking how long a query takes to execute directly from your database. If the database itself takes, say, 9 seconds, it's perfectly normal for TypeORM to receive the data in around 10 seconds due to the latency involved in communicating with your NestJS application.

A good first step might be to select only the columns you're actually using. If it's still slow, then consider adding indexes.