Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020330 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] I. Performance | major | always | 2012-04-23 13:45 | 2012-04-24 08:43 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0MP11 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 1853df5df43d | |||
| Projection | none | ETA | none | Target Version | 3.0MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP10 | 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 | 0020330: Performance problem when clicking on the checbox of the pickandexecute refernce when having a lot of rows on m_producprice table | |||||||
| Description | Performance 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% | |||||||
| Tags | Performance | |||||||
| Attached Files |  request-product-selector.png [^] (74,802 bytes) 2012-04-23 14:27
no-request-product-selector.png [^] (61,093 bytes) 2012-04-23 14:27
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |