postgres « Performance « JPA Q&A





1. postgres performance using JPA&Hibernate    stackoverflow.com

I have the below piece of code running with different response times for the same input parameters among two different threads(which are sequential). What can cause this?

Query query = em.createQuery("SELECT ...

2. Performance problem with postgres    forum.hibernate.org

Author Message egervari Post subject: Performance problem with postgres Posted: Thu Jan 27, 2005 1:50 pm Senior Joined: Sun Oct 26, 2003 5:05 am Posts: 139 I'm having a pretty severe performance problem with postgres/hibernate fetching where the query takes around 250ms and I'd rather it takes around 20 or 30ms if possible since this query is used the ...

3. mysql postgres performance (surprise!)    forum.hibernate.org

I have two class hierarchies with depths of 4 and 5. They are mapped using table-per-class strategy. Hierarchies have several one-to-many relationships, all in same direction (one hierarchy is always parent, the other always child). The parent side uses lazy fetching (of child collections), and the child side uses eager fetching (of parent). Everything works fine. One use case shows a ...

4. Select Performance with Postgres    forum.hibernate.org

Everytime Hibernate (or any JDBC based application) sends a query to a database, you get an huge overhead : you've got to create the query, serialize it to TCP/IP, chat a bit in JDBC with the DB, wait for a response, switch to the DB process, get the query, parse it, execute it, send the result to TCP/IP, switch to the ...