Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performanceminorhave not tried2022-06-21 13:432022-06-22 14:38
ReportershankarbView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0049617: Index in session table

DescriptionAdding an index (username,login_status) on the ad_session table improves the performance across the System during API calls. Noticed this while analyzing the query performance in CSU customer. Contact Egoitz if there are any doubts.
Steps To ReproduceGeneral speed in query results after adding the index in API calls.
Proposed SolutionAdd the index (username,login_status) on the ad_session
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2022-06-21 13:43 shankarb New Issue
2022-06-21 13:43 shankarb Assigned To => Triage Platform Base
2022-06-21 13:43 shankarb Modules => Core
2022-06-21 13:43 shankarb Triggers an Emergency Pack => No
2022-06-21 13:58 shankarb Description Updated View Revisions
2022-06-21 13:58 shankarb Steps to Reproduce Updated View Revisions
2022-06-22 14:38 rafaroda Tag Attached: NOR

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker