Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0016024 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | sometimes | 2011-02-22 16:56 | 2011-03-01 00:00 | |||
Reporter | alostale | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 87f91199fb30 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0016024: Slow login | |||||||
Description | When 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 Reproduce | This 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
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 |