[ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13086452#comment-13086452 ]
Arun Kumar Sri commented on OFBIZ-4366: --------------------------------------- I apologize for sticking with Version 4 and not moving for further versions as my client wont pay for that :) Apologize that i did not give much information whilst describing the bug. So the bug statement is: "Accessing UtilCache Object for more than 200 times in a single request is taking more than 4 seconds to fetch the cached entity results ". My application is deployed in Weblogic Server. I traced the code within Ofbiz and found that core component is using the connection pool that is created in Weblogic Server to connect to DB. Is this called as "minerve connection pool management". Then how do we change the implementation to Apache DBCP? I found it is taking around 8 ms to read the one value from Cache. UtilCache is a sycnhornized one. So imagine 1000 times we are reading the UtilCache object in a single request. (1000*8ms) is not desirable one for a webpage wher my customers would stop using either! :( So this some thing i can fix or should i change my implementation to not to use the UtilCache often . Any ideas would really help me. > Accessing Ofbiz Entity UtilCache is time consuming > -------------------------------------------------- > > Key: OFBIZ-4366 > URL: https://issues.apache.org/jira/browse/OFBIZ-4366 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: Release 4.0 > Environment: Producttion Environment Issue. In one particular > request, we are accessing UtilCache object 200 times via Generic Delegator, > findByConditionCache and findCache methods to read entity values. > Reporter: Arun Kumar Sri > Assignee: Jacques Le Roux > Labels: api-change > Fix For: Release Branch 4.0 > > Original Estimate: 0.05h > Remaining Estimate: 0.05h > > Its have been found that it is taking 3 to 4 seconds only for that. Is this > some thing that how is built or ? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira