Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016025Openbravo ERPA. Platformpublic2011-02-22 16:562011-02-28 18:14
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016025: Slow login
DescriptionWhen the number of sessions increases, login becomes very slow.

The problem is in the query executed to check failed logins which is only needed in case Log in security option is enabled.
Steps To ReproduceThis has been reported in butler instance where there is ~100000 sessions.

It also depends on the user that is doing login.
Proposed Solution-Don't execute this query if not needed.
-Add an index to ad_session for username column which will improve performance when query is needed.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0016024 closed alostale Slow login 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-22 16:59alostaleTypedefect => backport
2011-02-22 16:59alostalefix_in_branch => 2.50
2011-02-22 17:01hgbotCheckin
2011-02-22 17:01hgbotNote Added: 0034317
2011-02-22 17:01hgbotStatusscheduled => resolved
2011-02-22 17:01hgbotResolutionopen => fixed
2011-02-22 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/b6c443c2b20d86899cf40efda1fc879f31e1ea48 [^]
2011-02-28 18:14marvintmNote Added: 0034437
2011-02-28 18:14marvintmStatusresolved => closed

Notes
(0034317)
hgbot   
2011-02-22 17:01   
Repository: erp/stable/2.50
Changeset: b6c443c2b20d86899cf40efda1fc879f31e1ea48
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Feb 22 17:00:38 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/b6c443c2b20d86899cf40efda1fc879f31e1ea48 [^]

fixed bug 16025: Slow login

---
M src-db/database/model/tables/AD_SESSION.xml
M src/org/openbravo/base/secureApp/UserLock.java
---
(0034437)
marvintm   
2011-02-28 18:14   
Tested that with 10000 entries in the ad_session table the login works fine.