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

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -