Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031696
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2015-12-11 10:532018-11-22 09:39
ReporteralostaleView Statuspublic 
Assigned Toplatform 
PriorityhighResolutionfixedFixed in Version3.0PR19Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031696: 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.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0028478 closedNaroaIriarte view generation: unneeded queries to grid config tables 
related to design defect 0037999 closedplatform Performance issue opening a window with hundreds of fields distributed on different tabs. 
blocks design defect 0039670 closedalostale view generation scalability issues 

-  Notes
(0108050)
alostale (manager)
2018-11-22 09:39

 Fixed by 0039670

- Issue History
Date Modified Username Field Change
2015-12-11 10:53 alostale New Issue
2015-12-11 10:53 alostale Assigned To => platform
2015-12-11 10:53 alostale Modules => Core
2015-12-11 10:53 alostale Triggers an Emergency Pack => No
2015-12-11 10:54 alostale Relationship added related to 0028478
2015-12-11 10:54 alostale Status new => acknowledged
2015-12-11 10:54 alostale Tag Attached: Performance
2016-12-01 14:05 alostale Priority normal => urgent
2016-12-01 14:05 alostale Priority urgent => high
2018-03-09 10:40 alostale Relationship added related to 0037999
2018-11-22 09:13 alostale Relationship added blocks 0039670
2018-11-22 09:38 alostale Status acknowledged => scheduled
2018-11-22 09:39 alostale Note Added: 0108050
2018-11-22 09:39 alostale Status scheduled => closed
2018-11-22 09:39 alostale Resolution open => fixed
2018-11-22 09:39 alostale Fixed in Version => 3.0PR19Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker