Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037999Openbravo ERPA. Platformpublic2018-02-26 11:552018-11-22 09:40
Reporteregoitz 
Assigned Toplatform 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037999: Performance issue opening a window with hundreds of fields distributed on different tabs.
DescriptionThe request to the view component that builds the window when opening a window takes long if there are hundreds (>600) of fields on different tabs.
Steps To ReproduceCreate many new fiedls on the Sales invoice window and open the window.
The execution takes arround 10 seconds.
Proposed SolutionAfter fix 0038066 this issue is less severe. Moved to design defect as a important performance refactor needs to be done in order to improve view generation.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031696 closed platform unneeded queries to OBUIAPP_GC_System when generating views 
related to design defect 0039670 closed alostale view generation scalability issues 
related to defect 0038066 closed alostale incorrect view cache in browser for windows with server display logic 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-26 11:55egoitzNew Issue
2018-02-26 11:55egoitzAssigned To => platform
2018-02-26 11:55egoitzModules => Core
2018-02-26 11:55egoitzTriggers an Emergency Pack => No
2018-03-01 09:16egoitzResolution time => 1521068400
2018-03-01 09:16egoitzNote Added: 0102892
2018-03-01 09:16egoitzSeverityminor => major
2018-03-01 09:16egoitzProposed Solution updated
2018-03-01 16:41shuehnerNote Added: 0102904
2018-03-07 12:50egoitzNote Added: 0103054
2018-03-07 18:09egoitzRelationship addedrelated to 0038066
2018-03-09 10:40alostaleRelationship addedrelated to 0031696
2018-03-09 13:21alostaleResolution time1521068400 =>
2018-03-09 13:21alostaleSeveritymajor => minor
2018-03-09 13:21alostaleStatusnew => acknowledged
2018-03-09 13:21alostaleTypedefect => design defect
2018-03-09 13:21alostaleProposed Solution updated
2018-11-22 09:12alostaleRelationship addedrelated to 0039670
2018-11-22 09:39alostaleStatusacknowledged => scheduled
2018-11-22 09:40alostaleNote Added: 0108051
2018-11-22 09:40alostaleStatusscheduled => closed
2018-11-22 09:40alostaleResolutionopen => fixed
2018-11-22 09:40alostaleFixed in Version => 3.0PR19Q1

Notes
(0102892)
egoitz   
2018-03-01 09:16   
With the following index one second is reduced but it is not enough:

CREATE INDEX ad_field_trl_field
  ON ad_field_trl
  USING btree
  (ad_field_id COLLATE pg_catalog."default");
(0102904)
shuehner   
2018-03-01 16:41   
Hello,
pi already has this:
    "ad_field_trl_field_language_un" UNIQUE CONSTRAINT, btree (ad_field_id, ad_l

unique constraint which has automatically and index which should work the same.

Given that the new proposed index should not be needed in theory
(0103054)
egoitz   
2018-03-07 12:50   
The view is created the first time after the login but not on next times that the window is opened.
after logout and login the view is created again?
Could be possible to cache that on the browser or at applicatoin level?
(0108051)
alostale   
2018-11-22 09:40   
Fixed by 0039670