Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0021783 | Retail Modules | Web POS | public | 2012-09-28 10:48 | 2012-10-31 10:55 |
|
| Reporter | iperdomo | |
| Assigned To | adrianromero | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | 3.5.4-1-ARCH |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0021783: Remove from the JSON reponse the data not used in the Web POS client |
| Description | When a developer defines a HQL like this one: "from Product" the ProcessHQLQuery uses the FULL entity resolving mode, this adds useless information in the resulting in a huge JSON response (client, organization, created, createdBy, updated, updatedBy) |
| Steps To Reproduce | See the amount of data transfered from the server to the client, e.g. ProductPrice
With 75K products, the amount of data is ~60MB, just sending the required information is ~14MB (see the attached patch) |
| Proposed Solution | Modify the ProcessHQLQuery and filter out the audit fields, client and organization |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  ProductPrice.java.diff (1,885) 2012-09-28 10:48
https://issues.openbravo.com/file_download.php?file_id=5611&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-09-28 10:48 | iperdomo | New Issue | |
| 2012-09-28 10:48 | iperdomo | Assigned To | => adrianromero |
| 2012-09-28 10:48 | iperdomo | File Added: ProductPrice.java.diff | |
| 2012-09-28 10:48 | iperdomo | OBNetwork customer | => No |
| 2012-10-03 17:48 | hgbot | Checkin | |
| 2012-10-03 17:48 | hgbot | Note Added: 0053021 | |
| 2012-10-03 17:48 | hgbot | Status | new => resolved |
| 2012-10-03 17:48 | hgbot | Resolution | open => fixed |
| 2012-10-03 17:48 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/33d9ea5564d39847988bdaf0b0bb97e035950d23 [^] |
| 2012-10-16 17:18 | hgbot | Checkin | |
| 2012-10-16 17:18 | hgbot | Note Added: 0053382 | |
| 2012-10-16 17:18 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/33d9ea5564d39847988bdaf0b0bb97e035950d23 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/33d9ea5564d39847988bdaf0b0bb97e035950d23 [^] |
| 2012-10-24 17:28 | adrianromero | Note Added: 0053655 | |
| 2012-10-24 17:28 | adrianromero | Status | resolved => closed |
| 2012-10-31 09:36 | hgbot | Checkin | |
| 2012-10-31 09:36 | hgbot | Note Added: 0053867 | |
| 2012-10-31 09:36 | hgbot | Status | closed => resolved |
| 2012-10-31 09:36 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-discounts/rev/33d9ea5564d39847988bdaf0b0bb97e035950d23 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-gal/rev/33d9ea5564d39847988bdaf0b0bb97e035950d23 [^] |
| 2012-10-31 10:55 | adrianromero | Status | resolved => closed |