Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023934Openbravo ERPA. Platformpublic2013-05-29 11:462013-06-01 02:14
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP24 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023934: Sequential scan on AD_Session when logging in
DescriptionWhen user logs in the application a sequential scan is performed to AD_Session table.

This table keeps track of all historical sessions in the application so it can become huge, potentially slowing down the log in process.
Steps To ReproduceWithin a professional instance with concurrent users limitation log in the application, check the number of sequential scans in ad_session increases by 1 each time.
Proposed Solution
Additional Information
TagsPerformance
Relationships
blocks design defect 0023428 new AugustoMauch When login the application the cpu consumes a lot of resources for few seconds and the memory also increases a lot 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-29 11:46alostaleNew Issue
2013-05-29 11:46alostaleAssigned To => alostale
2013-05-29 11:46alostaleModules => Core
2013-05-29 11:46alostaleTriggers an Emergency Pack => No
2013-05-29 11:47alostaleTag Attached: Performance
2013-05-29 11:48alostaleRelationship addedblocks 0023428
2013-05-29 12:15alostaleSummarySequential scan on AD_Session => Sequential scan on AD_Session when logging in
2013-05-29 12:16alostaleReview Assigned To => shankarb
2013-05-29 12:16hgbotCheckin
2013-05-29 12:16hgbotNote Added: 0059016
2013-05-29 12:16hgbotStatusnew => resolved
2013-05-29 12:16hgbotResolutionopen => fixed
2013-05-29 12:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f6a4fd1a4a26d13128dc1071197dc506c11385a7 [^]
2013-05-30 12:11shankarbNote Added: 0059067
2013-05-30 12:11shankarbStatusresolved => closed
2013-05-30 12:11shankarbFixed in Version => 3.0MP24
2013-06-01 02:14hudsonbotCheckin
2013-06-01 02:14hudsonbotNote Added: 0059099

Notes
(0059016)
hgbot   
2013-05-29 12:16   
Repository: erp/devel/pi
Changeset: f6a4fd1a4a26d13128dc1071197dc506c11385a7
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 29 12:16:05 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f6a4fd1a4a26d13128dc1071197dc506c11385a7 [^]

fixed bug 23934: sequential scan on AD_Session when logging in

---
M src-db/database/model/tables/AD_SESSION.xml
---
(0059067)
shankarb   
2013-05-30 12:11   
Code reviewed in pi changeset 9708bd1d96eb
(0059099)
hudsonbot   
2013-06-01 02:14   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/31f9b82dde77 [^]

Maturity status: Test