hibernate criteria query performance -
in project , doing search on parameters using hibernate criteria query. return 300-400 records in soap response(after small processing logic applied) taking around 9-10 mins in eclipse junit test case.
after enabling logging level trace , observed same query executes 2 times or 3 times (this might issue not understanding it's reason).
e.g.
select * ( select this.id _id..... select * ( select this.id _id..... select * ( select this.id _id.....
to fix performance issue ,i cannot change in db entities , relation.
wanted check if can in hibernate criteria query improve performance.
below code used while doing search .i doubting on below code .just analyzing commented below code , executed junit still there no improvement in performance.
criteria.setresulttransformer(criteria_distinct_entity); criteria.createalias("name","name",criteriaspecification.left_join); criteria.createorder(..);
can suggest can improve criteria query performance.
Comments
Post a Comment