You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Arun Kumar Sri (JIRA)" <ji...@apache.org> on 2011/08/11 21:26:27 UTC

[jira] [Created] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

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
             Fix For: Release Branch 4.0


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

        

[jira] [Closed] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Jacques Le Roux (Closed) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-4366.
----------------------------------

    
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Arun Kumar Sri (JIRA)" <ji...@apache.org>.
    [ 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

        

[jira] [Reopened] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Arun Kumar Sri (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arun Kumar Sri reopened OFBIZ-4366:
-----------------------------------


> 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

        

[jira] [Commented] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Arun Kumar Sri (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13083419#comment-13083419 ] 

Arun Kumar Sri commented on OFBIZ-4366:
---------------------------------------

We have been using Ofbiz Framework for around 3 years. All these days, we are not using some expensive operation to access 300 in a single request. 
But now the some design constraints are forcing to do this. We will be changing the design to some how reduce this.
How ever, at the same time, reading from UtilCache [a map within it] should not take this much seconds. Can you help us with this! 



> 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
>              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

        

[jira] [Resolved] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Jacopo Cappellato (Resolved) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato resolved OFBIZ-4366.
--------------------------------------

    Resolution: Won't Fix

The release branch 4.0 is no more actively maintained.
                
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Closed] (OFBIZ-4366) Accessing Ofbiz Entity UtilCache is time consuming

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-4366.
----------------------------------

    Resolution: Not A Problem
      Assignee: Jacques Le Roux

Sorry, though there is no official policy (we lack one, I will begin a discussion about it) the release 4.0 is not supported (much) anymore. So, except fro trivial question, don't expect much support on.

2 other points:
# This is not a bug. Anyway a  bug would more descriptive information. It's better to ask question on user ML.
# One way you could try is to replace the Minverva connection pool management by Apache DBCP. This has been done just after the rel. 4.0 because there were some problems with it. Unfortunately, IIRW, they were no performance issues. But you could still try to upgrade this part. Also I'd check how much memory you have available...

> 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