Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0015193 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 02. Master data management | minor | always | 2010-11-15 18:01 | 2011-02-08 00:00 | |||
Reporter | adrianromero | View Status | public | |||||
Assigned To | marvintm | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | . | ||||
Projection | none | ETA | none | Target Version | 3.0RC4 | |||
OS | Any | Database | PostgreSQL | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 3.0RC2 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0015193: Performance problem in role window when there are many warehouses defined | |||||||
Description | We have an application with more that 200 warehouses defined. When the user tries to open the role window (the first link in the menu), the window takes a lot of time. | |||||||
Steps To Reproduce | - Create some warehouses (we have more that 200). - Access to role information (first link in the menu) - Notice that it takes a lot of time. Note that the action save in this window takes a lot of time, too. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0032690) mtaal (manager) 2010-11-17 20:17 |
I am not sure if this is an issue, it can be. One thing is that the loading of the role info is done asynchronously while the application loads. So the user won't see a delay (unless he within a second after the application shows opens the role window). But still the server is hit and this may cause performance problems. Tjhe querying in the new role window does this: read all roles of one client for each role read the organizations for each role and all organizations (of that role), read all warehouses So also in this case there can be many queries indeed. For example with 10 clients and 10 roles, there are: 100 queries for organizations 100 queries for warehouses So a performance improvement would bring this down to two queries. for organizations and one for warehouses and do the linking of roles/organizations and warehouses on the server side. Assigning it to myself for now. |
(0032723) mtaal (manager) 2010-11-19 06:36 |
Note that the above changes should be done in this class/method: org.openbravo.client.application.navigationbarcomponents.UserInfoWidgetActionHandler and this method: executeDataCommand The changes mean that only one or 2 queries should be used. The linking of the organization/warehouse to the correct role should then be done in memory instead of going through the database. In addition the queries can be optimized a bit by not reading the complete object but only dedicated fields. gr. Martin |
(0034068) marvintm (developer) 2011-02-07 12:01 |
Two different databases have been tested: - One with a small number of organizations, and 3000 warehouses - One with 50 organizations, and 50 warehouses each (so 2500 warehouses in total). In both cases, the menu is very responsible and loads instantly, so no problems were detected in the 3.0 environment. |
Issue History | |||
Date Modified | Username | Field | Change |
2010-11-15 18:01 | adrianromero | New Issue | |
2010-11-15 18:01 | adrianromero | Assigned To | => adrianromero |
2010-11-15 18:01 | adrianromero | Issue generated from | 0015064 |
2010-11-15 18:01 | adrianromero | Relationship added | blocks 0015064 |
2010-11-15 18:32 | adrianromero | Target Version | => 3.0RC4 |
2010-11-17 20:17 | mtaal | Note Added: 0032690 | |
2010-11-17 20:17 | mtaal | Assigned To | adrianromero => mtaal |
2010-11-19 06:36 | mtaal | Note Added: 0032723 | |
2010-12-20 13:50 | adrianromero | Severity | major => minor |
2010-12-20 13:50 | adrianromero | Type | backport => defect |
2010-12-27 07:27 | alostale | Status | new => scheduled |
2011-01-12 12:29 | shuehner | Issue Monitored: shuehner | |
2011-01-24 18:51 | adrianromero | Priority | high => urgent |
2011-02-03 09:48 | dalsasua | Assigned To | mtaal => marvintm |
2011-02-07 12:01 | marvintm | Note Added: 0034068 | |
2011-02-07 12:01 | marvintm | Status | scheduled => resolved |
2011-02-07 12:01 | marvintm | Fixed in SCM revision | => . |
2011-02-07 12:01 | marvintm | Resolution | open => fixed |
2011-02-07 12:02 | marvintm | Status | resolved => closed |
2011-02-08 00:00 | anonymous | sf_bug_id | 0 => 3175409 |
Copyright © 2000 - 2009 MantisBT Group |