Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031696Openbravo ERPA. Platformpublic2015-12-11 10:532018-11-22 09:39
Reporteralostale 
Assigned Toplatform 
PriorityhighSeverityminorReproducibilityhave not tried
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
Summary0031696: unneeded queries to OBUIAPP_GC_System when generating views
DescriptionWhen standard views are generated, grid configuration at system level is queried once per field. It should only be queried once (at most) because its value is always identical for all fields.
Steps To Reproduce-Set pg to log all queries
-Open BP window
-Check there are around 300 queries Obuiapp_Gc_System table
Proposed SolutionThis value should be cached (TBD at which level), note Obuiapp_Gc_System is not part of source code so, cache should be invalidated when it changes.
Additional Information
TagsPerformance
Relationships
related to defect 0028478 closed NaroaIriarte view generation: unneeded queries to grid config tables 
related to design defect 0037999 closed platform Performance issue opening a window with hundreds of fields distributed on different tabs. 
blocks design defect 0039670 closed alostale view generation scalability issues 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-11 10:53alostaleNew Issue
2015-12-11 10:53alostaleAssigned To => platform
2015-12-11 10:53alostaleModules => Core
2015-12-11 10:53alostaleTriggers an Emergency Pack => No
2015-12-11 10:54alostaleRelationship addedrelated to 0028478
2015-12-11 10:54alostaleStatusnew => acknowledged
2015-12-11 10:54alostaleTag Attached: Performance
2016-12-01 14:05alostalePrioritynormal => urgent
2016-12-01 14:05alostalePriorityurgent => high
2018-03-09 10:40alostaleRelationship addedrelated to 0037999
2018-11-22 09:13alostaleRelationship addedblocks 0039670
2018-11-22 09:38alostaleStatusacknowledged => scheduled
2018-11-22 09:39alostaleNote Added: 0108050
2018-11-22 09:39alostaleStatusscheduled => closed
2018-11-22 09:39alostaleResolutionopen => fixed
2018-11-22 09:39alostaleFixed in Version => 3.0PR19Q1

Notes
(0108050)
alostale   
2018-11-22 09:39   
Fixed by 0039670