Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016024
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorsometimes2011-02-22 16:562011-03-01 00:00
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision87f91199fb30
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016024: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0016025 closedalostale Slow login 

-  Notes
(0034318)
hgbot (developer)
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 (developer)
2011-02-28 18:14

Tested that with 10000 entries in the ad_session table the login works fine.

- Issue History
Date Modified Username Field Change
2011-02-22 16:56 alostale New Issue
2011-02-22 16:56 alostale Assigned To => alostale
2011-02-22 16:56 alostale Modules => Core
2011-02-22 16:59 alostale Status new => scheduled
2011-02-22 16:59 alostale fix_in_branch => pi
2011-02-22 17:01 hgbot Checkin
2011-02-22 17:01 hgbot Note Added: 0034318
2011-02-22 17:01 hgbot Status scheduled => resolved
2011-02-22 17:01 hgbot Resolution open => fixed
2011-02-22 17:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/87f91199fb309842bbcdb8bcc9f28e444a3d38ae [^]
2011-02-28 18:14 marvintm Note Added: 0034436
2011-02-28 18:14 marvintm Status resolved => closed
2011-03-01 00:00 anonymous sf_bug_id 0 => 3195613


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker