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
