Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033677Openbravo ERPB. User interfacepublic2016-08-10 11:162017-07-28 11:20
Reportershuehner 
Assigned Toplatform 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033677: 'Refresh' of widgets in workspace takes very long with user having access to many organizations
DescriptionIn an environment with 524 organization and a user having access to them (i.e. Openbravo user) the request behind 'Refresh' of widgets of workspace (also done during login) takes very long (4-5seconds)

Also it is doing a very high number of sql-queries as it seems to loop over all those organizations and doing at least
1.) ad org lookup
2.) widget instance search

for the 'copyWidgets' function.

Note: getProxy is not full fix as some code in MyOBUtils.getDefaultWidgetInstances reads client from the org object.

widgetInstancesCrit.add(Restrictions.eq(WidgetInstance.PROPERTY_CLIENT,
          organization.getClient()));
Steps To ReproduceCheck runtime of that request
Trace sqls done during this request.
Proposed Solution
Additional Information
TagsPerformance
Relationships
duplicate of feature request 0035980 closed caristu Improve the time spent to load the widgets after log-in 
Attached Filesdiff 33677_partial.diff (4,564) 2016-08-10 11:17
https://issues.openbravo.com/file_download.php?file_id=9705&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-08-10 11:16shuehnerNew Issue
2016-08-10 11:16shuehnerAssigned To => platform
2016-08-10 11:16shuehnerOBNetwork customer => No
2016-08-10 11:16shuehnerModules => Core
2016-08-10 11:16shuehnerTriggers an Emergency Pack => No
2016-08-10 11:16shuehnerTag Attached: Performance
2016-08-10 11:17shuehnerFile Added: 33677_partial.diff
2016-08-10 11:18shuehnerNote Added: 0088938
2016-12-01 13:06alostaleStatusnew => acknowledged
2016-12-01 14:03alostalePrioritynormal => high
2017-07-28 11:20alostaleStatusacknowledged => scheduled
2017-07-28 11:20alostaleNote Added: 0098259
2017-07-28 11:20alostaleStatusscheduled => closed
2017-07-28 11:20alostaleResolutionopen => out of date
2017-07-28 11:20alostaleRelationship addedduplicate of 0035980

Notes
(0088938)
shuehner   
2016-08-10 11:18   
Partial patch only for a start, not fixing the whole issue.
(0098259)
alostale   
2017-07-28 11:20   
fixed by 0035980