Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 3.0.5
Database: Postgres 8.1
Is there any way to reduce the latency for querying?
I have got a huge number of queries that are generated as simple select statements by hibernate. One select statement needs approx 30ms to return back a result and if I have got 1000 of them then I get a response time of 30000ms (30secs).
If I execute those 1000 select statements with psql or pgAdmin it takes about 50ms to generate a result.
I already tried to use pooled connection using org.apache.commons.dbcp.BasicDataSource but the performance gain is marginal and not notworthy.
Another thing I tried ist to deactive transaction services at all but I got no better results.
What other ways do I have to improve latency performance using Hibernate?
Such latency times using hibernate makes the use of databases useless from my point of view.