How much data can Hibernate handle?

Question

Java

There is a base on PostgreSQL, an application in Java. There are about 10 tables in the database, interconnected. Each table is filled with 10k to 500k rows every month.
How efficient is the use of Hibernate in this case, if you have to query the data for the current month and for the year as a whole very often?

Answer 1

what does Hibernate have to do with it? it's just an ORM, the same sql queries sit inside, precompilation of selects gives the same speed, performance rather depends on the cache of the postgress itself

Answer 2

If you need to fill in such tables from other sources, then jdbc with batch insert (without hibernate), it is possible in several threads.
If select queries are complex enough, then I prefer to use stored procedures that return a cursor. And this cursor can already be processed through hibernate.