EJB programming & troubleshooting: EJB3-Query In the same transaction become slower and slower

  1. In our system EJB3 is used. and we need to execute the same HQL for many many times in the same transaction. For some business reason , we can not change the process. Now we find execution of the same HQL becoming slower and slower(from mileseconds to half a minute) in the same transation. can anyone give me help?
  2. Check your data load. I guess data load is getting heavier with the time. Therefore better to optimize your queries thinking about them. Anyway you can post your queries here, so we can also have a look and see whether there is any issue.
  3. If not, may be[ Go to top ]

    Do you use hibernate caching? It can be used && fine-tuned in anyway..