Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037585 | Retail Modules | Web POS | public | 2018-01-04 16:56 | 2018-02-07 16:47 |
|
| Reporter | Sandrahuguet | |
| Assigned To | Sandrahuguet | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Openbravo Appliance 14.04 |
| Product Version | | |
| Target Version | | Fixed in Version | RR18Q2 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0037585: Performance problem in BPLocation query during the incremental refresh |
| Description | Performance problem in BPLocation query during the incremental refresh
In environment with the following data:
116337 business partner
116828 bp location
117940 location
the query takes around 2.2s
|
| Steps To Reproduce | Log in ERP
-Go to posterminal type window and select "VBS POS Terminal Type"
-Set Time to incrementally refresh masterdata to 1
Log in the WebPOS using VBS-1
-wait until the incremental refresh will be launched |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0037869 | | closed | Sandrahuguet | Performance improvements in BPLocation query |
|
| Attached Files |  BPLocation_2.diff (2,729) 2018-01-08 10:15
https://issues.openbravo.com/file_download.php?file_id=11433&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-01-04 16:56 | Sandrahuguet | New Issue | |
| 2018-01-04 16:56 | Sandrahuguet | Assigned To | => Retail |
| 2018-01-04 16:56 | Sandrahuguet | Triggers an Emergency Pack | => No |
| 2018-01-04 16:56 | Sandrahuguet | Tag Attached: Performance | |
| 2018-01-04 17:12 | maite | Resolution time | => 1485298800 |
| 2018-01-04 17:13 | maite | Issue Monitored: networkb | |
| 2018-01-04 17:59 | Sandrahuguet | File Added: 37585.diff | |
| 2018-01-04 17:59 | Sandrahuguet | File Deleted: 37585.diff | |
| 2018-01-04 18:01 | Sandrahuguet | File Added: 37585.diff | |
| 2018-01-04 18:10 | Sandrahuguet | Note Added: 0101565 | |
| 2018-01-08 08:58 | marvintm | Resolution time | 1485298800 => 1516834800 |
| 2018-01-08 10:14 | Sandrahuguet | File Deleted: 37585.diff | |
| 2018-01-08 10:15 | Sandrahuguet | Note Deleted: 0101565 | |
| 2018-01-08 10:15 | Sandrahuguet | File Added: BPLocation_2.diff | |
| 2018-01-08 10:24 | Sandrahuguet | Note Added: 0101613 | |
| 2018-01-08 13:19 | Sandrahuguet | Assigned To | Retail => Sandrahuguet |
| 2018-01-08 13:26 | Sandrahuguet | Note Edited: 0101613 | bug_revision_view_page.php?bugnote_id=0101613#r16514 |
| 2018-01-08 17:21 | Sandrahuguet | Review Assigned To | => marvintm |
| 2018-01-08 17:22 | hgbot | Checkin | |
| 2018-01-08 17:22 | hgbot | Note Added: 0101623 | |
| 2018-01-08 17:22 | hgbot | Status | new => resolved |
| 2018-01-08 17:22 | hgbot | Resolution | open => fixed |
| 2018-01-08 17:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e6f6ab0f0d31ba2c93aa753cf1e99ecfc99d19ca [^] |
| 2018-01-09 13:57 | marvintm | Status | resolved => closed |
| 2018-01-09 13:57 | marvintm | Fixed in Version | => RR18Q2 |
| 2018-02-07 16:47 | Sandrahuguet | Note Added: 0102258 | |
| 2018-02-07 16:47 | Sandrahuguet | Note Edited: 0102258 | bug_revision_view_page.php?bugnote_id=0102258#r16647 |
| 2018-02-07 17:01 | Sandrahuguet | Note Edited: 0102258 | bug_revision_view_page.php?bugnote_id=0102258#r16648 |
| 2018-03-12 13:44 | Sandrahuguet | Relationship added | related to 0037869 |