Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0024810 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2013-09-23 11:02 | 2013-12-20 15:08 | |||
| Reporter | jecharri | View Status | public | |||||
| Assigned To | malsasua | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | RMP28 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 1c23d8d19ad0 | ||||
| Projection | none | ETA | none | Target Version | RMP28 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | guilleaer | |||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | 23175 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0024810: Performance problem during the cash up | |||||||
| Description | Performance problem during the cash up. If you are working with huge quantity of records in table c_orderline the cash up always is slow. I have one database where method "groupOrders" it takes 25-30 seconds to do a cash up withour any order (the problem is the query that we are executing, it is really slow) | |||||||
| Steps To Reproduce | -Login in web POS and try to execute a cash up | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0061563) hgbot (developer) 2013-10-07 11:13 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Mon Oct 07 11:13:06 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0061564) malsasua (viewer) 2013-10-07 11:16 |
Deleted the query section about fin_payment_schedule_detail don't exist. When a SO is paid with an advanced payment, the invoice is created in that moment. Then, in the cashup process, this SO should be ignored |
|
(0061595) guilleaer (viewer) 2013-10-07 17:44 |
verified |
|
(0061606) hgbot (developer) 2013-10-08 11:42 |
Repository: erp/pmods/org.openbravo.retail.posterminal-levelpricing Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Mon Oct 07 11:13:06 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0061615) guilleaer (viewer) 2013-10-08 11:44 |
reclosing |
|
(0061689) hgbot (developer) 2013-10-16 10:19 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Wed Oct 16 10:18:32 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0061700) hgbot (developer) 2013-10-16 13:38 |
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque Changeset: 5fb5f532e4f8b3a9475c03406e343adb0087bb3f Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Mon Oct 07 11:13:06 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0061715) hgbot (developer) 2013-10-16 13:41 |
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Wed Oct 16 10:18:32 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0061788) guilleaer (viewer) 2013-10-17 18:32 |
reclosed |
|
(0062157) hgbot (developer) 2013-11-18 06:54 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80 Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com> Date: Fri Nov 08 12:30:34 2013 +0000 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0062172) hgbot (developer) 2013-11-18 12:51 |
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines Changeset: 4c11643ccb35ef2292507f1e44c37787e2ac2c1a Author: Miguel A. Alsasua <miguel.alsasua <at> openbravo.com> Date: Wed Oct 16 10:18:32 2013 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] Fixed issue 24810: Performance problem during the cash up --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0062206) hgbot (developer) 2013-11-18 12:56 |
Repository: erp/pmods/org.openbravo.retail.posterminal-splitlines Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80 Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com> Date: Fri Nov 08 12:30:34 2013 +0000 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0062574) hgbot (developer) 2013-12-05 12:12 |
Repository: erp/pmods/org.openbravo.retail.posterminal.cirque Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80 Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com> Date: Fri Nov 08 12:30:34 2013 +0000 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0062612) guilleaer (viewer) 2013-12-05 17:21 |
Reclosing |
|
(0062902) hgbot (developer) 2013-12-19 19:46 |
Repository: erp/pmods/org.openbravo.retail.posterminal.offline Changeset: 1c23d8d19ad06951aafd1612eaa0c778ed27ee80 Author: Priya Muthukumar <priya.muthukumar <at> openbravo.com> Date: Fri Nov 08 12:30:34 2013 +0000 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] Fixed issue 24810: Performance problem during the cash up. fixed issue 25081: Quotations lines are not invoiced when cash up is done --- M src/org/openbravo/retail/posterminal/OrderGroupingProcessor.java --- |
|
(0063001) guilleaer (viewer) 2013-12-20 15:08 |
reclosed |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-09-23 11:02 | jecharri | New Issue | |
| 2013-09-23 11:02 | jecharri | Assigned To | => marvintm |
| 2013-09-23 11:02 | jecharri | OBNetwork customer | => Yes |
| 2013-09-23 11:02 | jecharri | Support ticket | => 23175 |
| 2013-09-23 11:02 | jecharri | Resolution time | => 1382652000 |
| 2013-09-23 11:02 | jecharri | Triggers an Emergency Pack | => No |
| 2013-09-23 11:02 | jecharri | Tag Attached: Performance | |
| 2013-09-25 12:30 | umartirena | Assigned To | marvintm => umartirena |
| 2013-10-02 12:50 | marvintm | Assigned To | umartirena => malsasua |
| 2013-10-07 11:13 | hgbot | Checkin | |
| 2013-10-07 11:13 | hgbot | Note Added: 0061563 | |
| 2013-10-07 11:13 | hgbot | Status | new => resolved |
| 2013-10-07 11:13 | hgbot | Resolution | open => fixed |
| 2013-10-07 11:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] |
| 2013-10-07 11:16 | malsasua | Note Added: 0061564 | |
| 2013-10-07 17:44 | guilleaer | Review Assigned To | => guilleaer |
| 2013-10-07 17:44 | guilleaer | Note Added: 0061595 | |
| 2013-10-07 17:44 | guilleaer | Status | resolved => closed |
| 2013-10-07 17:44 | guilleaer | Fixed in Version | => RMP28 |
| 2013-10-08 11:42 | hgbot | Checkin | |
| 2013-10-08 11:42 | hgbot | Note Added: 0061606 | |
| 2013-10-08 11:42 | hgbot | Status | closed => resolved |
| 2013-10-08 11:42 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] |
| 2013-10-08 11:44 | guilleaer | Note Added: 0061615 | |
| 2013-10-08 11:44 | guilleaer | Status | resolved => closed |
| 2013-10-08 16:01 | ngarcia | Issue Monitored: ngarcia | |
| 2013-10-15 18:34 | malsasua | Relationship added | related to 0024942 |
| 2013-10-16 10:19 | hgbot | Checkin | |
| 2013-10-16 10:19 | hgbot | Note Added: 0061689 | |
| 2013-10-16 10:19 | hgbot | Status | closed => resolved |
| 2013-10-16 10:19 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-levelpricing/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] |
| 2013-10-16 10:53 | malsasua | Relationship deleted | related to 0024942 |
| 2013-10-16 13:38 | hgbot | Checkin | |
| 2013-10-16 13:38 | hgbot | Note Added: 0061700 | |
| 2013-10-16 13:38 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] |
| 2013-10-16 13:41 | hgbot | Checkin | |
| 2013-10-16 13:41 | hgbot | Note Added: 0061715 | |
| 2013-10-16 13:41 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/5fb5f532e4f8b3a9475c03406e343adb0087bb3f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] |
| 2013-10-17 18:32 | guilleaer | Note Added: 0061788 | |
| 2013-10-17 18:32 | guilleaer | Status | resolved => closed |
| 2013-11-18 06:54 | hgbot | Checkin | |
| 2013-11-18 06:54 | hgbot | Note Added: 0062157 | |
| 2013-11-18 06:54 | hgbot | Status | closed => resolved |
| 2013-11-18 06:54 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] |
| 2013-11-18 06:54 | priyam | Status | resolved => closed |
| 2013-11-18 12:51 | hgbot | Checkin | |
| 2013-11-18 12:51 | hgbot | Note Added: 0062172 | |
| 2013-11-18 12:51 | hgbot | Status | closed => resolved |
| 2013-11-18 12:51 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] |
| 2013-11-18 12:56 | hgbot | Checkin | |
| 2013-11-18 12:56 | hgbot | Note Added: 0062206 | |
| 2013-11-18 12:56 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/4c11643ccb35ef2292507f1e44c37787e2ac2c1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] |
| 2013-11-19 18:16 | marvintm | Status | resolved => closed |
| 2013-12-05 12:12 | hgbot | Checkin | |
| 2013-12-05 12:12 | hgbot | Note Added: 0062574 | |
| 2013-12-05 12:12 | hgbot | Status | closed => resolved |
| 2013-12-05 12:12 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal-splitlines/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] |
| 2013-12-05 17:21 | guilleaer | Note Added: 0062612 | |
| 2013-12-05 17:21 | guilleaer | Status | resolved => closed |
| 2013-12-19 19:46 | hgbot | Checkin | |
| 2013-12-19 19:46 | hgbot | Note Added: 0062902 | |
| 2013-12-19 19:46 | hgbot | Status | closed => resolved |
| 2013-12-19 19:46 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.cirque/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal.offline/rev/1c23d8d19ad06951aafd1612eaa0c778ed27ee80 [^] |
| 2013-12-20 15:08 | guilleaer | Note Added: 0063001 | |
| 2013-12-20 15:08 | guilleaer | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |