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.