aspose file tools
The moose likes Object Relational Mapping and the fly likes JPA query optimization Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply Bookmark "JPA query optimization" Watch "JPA query optimization" New topic
Author

JPA query optimization

debraj mallick
Ranch Hand

Joined: Mar 08, 2011
Posts: 188

hi all,

i have a table "Semiproduct" and have the id of the "Semiproduct", in tables "SemiproductSales" and "SupplyArea" as foreign key, say for example

entities "SemiproductSales" and "SupplyArea" have multiple "Semiproduct". Now when query on SemiproductSales

multiple queries are generated which reduces the performance, if the query result set is 5000 then 5001 queries are generated. what should i do?
I am using Hibernate implementation of JPA,
any help would be appreciated.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: JPA query optimization
 
Similar Threads
JPA [Collections]
Saving database records problem
How to Write Left Outer Join
JPA strange error.
Mysql auto generated PK used for another table and JPA