Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016025 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] A. Platform | major | sometimes | 2011-02-22 16:56 | 2011-02-28 18:14 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 2.50 | Fixed in SCM revision | b6c443c2b20d | |||
| 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 | 0016025: 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 ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0034317) hgbot (developer) 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 (developer) 2011-02-28 18:14 |
Tested that with 10000 entries in the ad_session table the login works fine. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-02-22 16:59 | alostale | Type | defect => backport |
| 2011-02-22 16:59 | alostale | fix_in_branch | => 2.50 |
| 2011-02-22 17:01 | hgbot | Checkin | |
| 2011-02-22 17:01 | hgbot | Note Added: 0034317 | |
| 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/stable/2.50/rev/b6c443c2b20d86899cf40efda1fc879f31e1ea48 [^] |
| 2011-02-28 18:14 | marvintm | Note Added: 0034437 | |
| 2011-02-28 18:14 | marvintm | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |