Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038708Retail ModulesWeb POSpublic2018-06-05 17:422018-06-06 10:38
Reporterjorge-garcia 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038708: BusinessPartner query from backend is slow if there exists 150.000+ rows
DescriptionBusinessPartner query from backend is slow if there exists 150.000+ rows.

After the analysis of the query, we detected that the performance problem was in the offset search of each page takes longer when the offset increase.
Steps To Reproduce1) Execute JMeter test with 400 terminals doing login in 5 minutes.
2) Wait until server starts to be overloaded.
3) Check pg_stack_activity from server and realize the problem is that db threads are being consuming mostly from business partner sqls.
Proposed SolutionInstead of using offset to get each page, use the alternative way of using the id to retrieve each page
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-06-05 17:42jorge-garciaNew Issue
2018-06-05 17:42jorge-garciaAssigned To => jorge-garcia
2018-06-05 17:42jorge-garciaOBNetwork customer => No
2018-06-05 17:42jorge-garciaTriggers an Emergency Pack => No
2018-06-05 17:42jorge-garciaTag Attached: Performance
2018-06-06 10:38jorge-garciaStatusnew => scheduled

There are no notes attached to this issue.