Discussions
EJB programming & troubleshooting: EJB3-Query In the same transaction become slower and slower
-
EJB3-Query In the same transaction become slower and slower (2 messages)
- Posted by: simon wang
- Posted on: May 13 2009 09:15 EDT
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?Threaded Messages (2)
- Re: EJB3-Query In the same transaction become slower and slower by Asiri Liyanage on May 20 2009 03:24 EDT
- If not, may be by Oguzhan Ceylan on May 22 2009 04:50 EDT
-
Re: EJB3-Query In the same transaction become slower and slower[ Go to top ]
- Posted by: Asiri Liyanage
- Posted on: May 20 2009 03:24 EDT
- in response to simon wang
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. -
If not, may be[ Go to top ]
- Posted by: Oguzhan Ceylan
- Posted on: May 22 2009 04:50 EDT
- in response to Asiri Liyanage
Do you use hibernate caching? It can be used && fine-tuned in anyway..