Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021157 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Retail Modules] Web POS | major | have not tried | 2012-07-19 15:48 | 2012-12-21 13:55 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | guilleaer | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | RMP18 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | RMP18 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021157: Doc num calculation will not scale | |||||||
| Description | Whenever POS application is loaded, next doc number needs to be calculated. Currently, this is done iterating over all orders generated from the terminal to get the maximum number. This won't scale if the number of orders is big enough. Also the query is using a like doc num, so index cannot be used. | |||||||
| Steps To Reproduce | - | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0050764) hgbot (developer) 2012-07-19 16:26 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 80406dfbc2754a6da3aa9c2e1fc6cc0b6549f10c Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Thu Jul 19 16:25:38 2012 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/80406dfbc2754a6da3aa9c2e1fc6cc0b6549f10c [^] Related to issue 21157: Perfomance improvements in sequence number initialization Changes: - Using ScrollableResults instead of list() - Retrieving the orders or a POS terminal filtering by em_obpos_applications_id instead of using a like query against the document number column. --- M src/org/openbravo/retail/posterminal/POSUtils.java M src/org/openbravo/retail/posterminal/term/Terminal.java --- |
|
(0055157) guilleaer (manager) 2012-12-21 13:55 |
fixed: https://issues.openbravo.com/view.php?id=22588 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-07-19 15:48 | alostale | New Issue | |
| 2012-07-19 15:48 | alostale | Assigned To | => adrianromero |
| 2012-07-19 15:49 | alostale | Relationship added | related to 0021156 |
| 2012-07-19 15:49 | alostale | Relationship added | related to 0021154 |
| 2012-07-19 15:49 | alostale | Relationship deleted | related to 0021156 |
| 2012-07-19 15:53 | alostale | Tag Attached: Performance | |
| 2012-07-19 16:26 | hgbot | Checkin | |
| 2012-07-19 16:26 | hgbot | Note Added: 0050764 | |
| 2012-07-25 10:40 | adrianromero | Relationship added | related to 0021194 |
| 2012-11-09 11:31 | adrianromero | Status | new => scheduled |
| 2012-11-09 11:31 | adrianromero | fix_in_branch | => pi |
| 2012-12-20 14:24 | adrianromero | Assigned To | adrianromero => guilleaer |
| 2012-12-20 14:25 | adrianromero | Target Version | => RMP18 |
| 2012-12-20 14:25 | adrianromero | fix_in_branch | pi => |
| 2012-12-21 13:52 | guilleaer | Relationship added | depends on 0022588 |
| 2012-12-21 13:55 | guilleaer | Relationship replaced | duplicate of 0022588 |
| 2012-12-21 13:55 | guilleaer | Note Added: 0055157 | |
| 2012-12-21 13:55 | guilleaer | Status | scheduled => closed |
| 2012-12-21 13:55 | guilleaer | Resolution | open => duplicate |
| 2012-12-21 13:55 | guilleaer | Fixed in Version | => RMP18 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |