[jira] [Created] (OFBIZ-4696) Performance issue: Excessive querying for UserLoginSecurityGroup

[Nicolas Malin (Jira)]

Performance issue: Excessive querying for UserLoginSecurityGroup
----------------------------------------------------------------

                 Key: OFBIZ-4696
                 URL: https://issues.apache.org/jira/browse/OFBIZ-4696
             Project: OFBiz
          Issue Type: Bug
          Components: framework
    Affects Versions: Release Branch 11.04, SVN trunk
            Reporter: Kiran Gawde


Turn on the timing logging for GenericDAO. And comment out the code that checks for 'queryTotalTime > 150' in GenericDAO class. Then you will notice that following query gets executed many times when you are browsing ofbiz backend applications. At least 40 times. It's a lightweight query, and backend application user may be limited. It would be nice to use cache.


[         GenericDAO.java:753:INFO ] Ran query in 0 milli-seconds:  EntityName: UserLoginSecurityGroup Sql: SELECT USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM USER_LOGIN_SECURITY_GROUP WHERE ((USER_LOGIN_ID = ?)) where clause:{USER_LOGIN_ID=admin}

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

       

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-4696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-4696.
----------------------------------

    Resolution: Not A Problem
      Assignee: Jacques Le Roux

I don't think we need to worry: Ran query in 0 milli-seconds
               

> Performance issue: Excessive querying for UserLoginSecurityGroup
> ----------------------------------------------------------------
>
>                 Key: OFBIZ-4696
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4696
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release Branch 11.04, SVN trunk
>            Reporter: Kiran Gawde
>            Assignee: Jacques Le Roux
>
> Turn on the timing logging for GenericDAO. And comment out the code that checks for 'queryTotalTime > 150' in GenericDAO class. Then you will notice that following query gets executed many times when you are browsing ofbiz backend applications. At least 40 times. It's a lightweight query, and backend application user may be limited. It would be nice to use cache.
> [         GenericDAO.java:753:INFO ] Ran query in 0 milli-seconds:  EntityName: UserLoginSecurityGroup Sql: SELECT USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM USER_LOGIN_SECURITY_GROUP WHERE ((USER_LOGIN_ID = ?)) where clause:{USER_LOGIN_ID=admin}

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