[ 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