0033677: 'Refresh' of widgets in workspace takes very long with user having access to many organizations

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0033677

Openbravo ERP

B. User interface

public

2016-08-10 11:16

2017-07-28 11:20

Reporter

shuehner

Assigned To

platform

Priority

high

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

out of date

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0033677: 'Refresh' of widgets in workspace takes very long with user having access to many organizations

Description

In 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 Reproduce

Check runtime of that request
Trace sqls done during this request.

Proposed Solution

Additional Information

Tags

Performance

Relationships

duplicate of

feature request

0035980

closed

caristu