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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020330
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2012-04-23 13:452012-04-24 08:43
ReporteregoitzView Statuspublic 
Assigned Toiperdomo 
PriorityurgentResolutionfixedFixed in Version3.0MP11
StatusclosedFix in branchpiFixed in SCM revision1853df5df43d
ProjectionnoneETAnoneTarget Version3.0MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP10SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020330: Performance problem when clicking on the checbox of the pickandexecute refernce when having a lot of rows on m_producprice table

DescriptionPerformance problem when clicking on the checbox of the pickandexecute refernce when having a lot of rows on m_producprice table
Steps To Reproduce-Define products and product prices to get arround 100.000 entries on the m_productprice table.
-Open the return shipment window
-Cick on pick&execute window
-Select a elment by clicking on the checbox
*The row is changes to editable and the cpu goes to 100%
TagsPerformance
Attached Filespng file icon request-product-selector.png [^] (74,802 bytes) 2012-04-23 14:27


png file icon no-request-product-selector.png [^] (61,093 bytes) 2012-04-23 14:27

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0020506 closedmarvintm Default filter value is not shown in selector grid the first time you open it 

-  Notes
(0047879)
iperdomo (reporter)
2012-04-23 14:26

Due the some logic, when a FormItem has an optionDataSource, SmartClient makes a request to get the possible values.
More info at: http://www.smartclient.com/docs/8.1/a/b/c/go.html#attr..FormItem.fetchMissingValues [^]

In the case of an editable line in a grid, SmartClient makes an item for each column. The product column is disabled in this case, but a request without filters was made to get the possible values (check the
request-product-selector.png file).

The fix is to set the fetchMissingValues at FormItem level to avoid this problem in all items.

After making the change no request is made to the product selector datasource (no-request-product-selector.png)
(0047880)
hgbot (developer)
2012-04-23 14:29

Repository: erp/devel/pi
Changeset: 1853df5df43d6d5efc8ab9fc8c62dfe416ca9acb
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Mon Apr 23 14:28:13 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1853df5df43d6d5efc8ab9fc8c62dfe416ca9acb [^]

Fixes issue 20330: Set the fetchMissingValues flag to false at FormItem level
- If fetchMissingValues is set to true, SmartClient makes a request on init() or
  setValue() when the FormItem has an optionDataSource

---
M modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/js/ob-smartclient.js
---
(0047895)
hudsonbot (developer)
2012-04-24 03:11

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2b25ce4cc3a9 [^]

Maturity status: Test
(0047896)
alostale (manager)
2012-04-24 08:43

Code reviewed and verified on pi@c1950986e5af

- Issue History
Date Modified Username Field Change
2012-04-23 13:45 egoitz New Issue
2012-04-23 13:45 egoitz Assigned To => iperdomo
2012-04-23 13:45 egoitz Modules => Core
2012-04-23 13:51 iperdomo Status new => scheduled
2012-04-23 13:51 iperdomo fix_in_branch => pi
2012-04-23 14:08 iperdomo Tag Attached: Performance
2012-04-23 14:26 iperdomo Note Added: 0047879
2012-04-23 14:27 iperdomo File Added: request-product-selector.png
2012-04-23 14:27 iperdomo File Added: no-request-product-selector.png
2012-04-23 14:29 hgbot Checkin
2012-04-23 14:29 hgbot Note Added: 0047880
2012-04-23 14:29 hgbot Status scheduled => resolved
2012-04-23 14:29 hgbot Resolution open => fixed
2012-04-23 14:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1853df5df43d6d5efc8ab9fc8c62dfe416ca9acb [^]
2012-04-24 03:11 hudsonbot Checkin
2012-04-24 03:11 hudsonbot Note Added: 0047895
2012-04-24 08:43 alostale Note Added: 0047896
2012-04-24 08:43 alostale Status resolved => closed
2012-04-24 08:43 alostale Fixed in Version => 3.0MP11
2012-05-15 13:53 iperdomo Relationship added related to 0020506


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker