Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016024Openbravo ERPA. Platformpublic2011-02-22 16:562011-03-01 00:00
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
Summary0016024: 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
depends on backport 0016025 closed alostale Slow login 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-22 16:56alostaleNew Issue
2011-02-22 16:56alostaleAssigned To => alostale
2011-02-22 16:56alostaleModules => Core
2011-02-22 16:59alostaleStatusnew => scheduled
2011-02-22 16:59alostalefix_in_branch => pi
2011-02-22 17:01hgbotCheckin
2011-02-22 17:01hgbotNote Added: 0034318
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/devel/pi/rev/87f91199fb309842bbcdb8bcc9f28e444a3d38ae [^]
2011-02-28 18:14marvintmNote Added: 0034436
2011-02-28 18:14marvintmStatusresolved => closed
2011-03-01 00:00anonymoussf_bug_id0 => 3195613

Notes
(0034318)
hgbot   
2011-02-22 17:01   
Repository: erp/devel/pi
Changeset: 87f91199fb309842bbcdb8bcc9f28e444a3d38ae
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Feb 22 16:59:44 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/87f91199fb309842bbcdb8bcc9f28e444a3d38ae [^]

Fixed bug 16024: Slow login

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