This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JPA query optimization

 
debraj mallick
Ranch Hand
Posts: 188
Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic