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?
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.
Do you use hibernate caching? It can be used && fine-tuned in anyway..