Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035375 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2017-02-28 10:45 | 2017-03-10 13:00 | |||
| Reporter | guillermogil | View Status | public | |||||
| Assigned To | guilleaer | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR17Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 7f86ae912c35 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | marvintm | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035375: Order by name is generating bad performance under some circustances | |||||||
| Description | On Product.java for Generic products query there is an Order by name that is generating bad performance under some circumstances. It should be removed as it is not useful for local database and not used in remote. | |||||||
| Steps To Reproduce | N/A | |||||||
| Proposed Solution | Remove Order by name | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0094897) hgbot (developer) 2017-03-10 09:36 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 7f86ae912c35e746d105bc204a76f76349e0b4a6 Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Thu Mar 09 12:47:28 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^] fixed Issue 35375: Remove order by from generic products query. It is not needed - It can be removed because this query is not being used when remote products is enabled - Using standard mode (loading masterdata to local DB) is not needed, because when products are shown in the browse tab a query is done against local DB using an order by --- M src/org/openbravo/retail/posterminal/master/Product.java --- |
|
(0094906) hgbot (developer) 2017-03-10 11:45 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 843d9442e2e29eae260bde1f3aac42a2b93b967a Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Fri Mar 10 11:40:14 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/843d9442e2e29eae260bde1f3aac42a2b93b967a [^] Related to issue 35375: Order by Product ID cannot be removed because it is needed by pagination --- M src/org/openbravo/retail/posterminal/master/Product.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-02-28 10:45 | guillermogil | New Issue | |
| 2017-02-28 10:45 | guillermogil | Assigned To | => Retail |
| 2017-02-28 10:45 | guillermogil | Triggers an Emergency Pack | => No |
| 2017-03-09 11:38 | guilleaer | Status | new => scheduled |
| 2017-03-09 11:38 | guilleaer | Assigned To | Retail => guilleaer |
| 2017-03-10 09:36 | hgbot | Checkin | |
| 2017-03-10 09:36 | hgbot | Note Added: 0094897 | |
| 2017-03-10 09:36 | hgbot | Status | scheduled => resolved |
| 2017-03-10 09:36 | hgbot | Resolution | open => fixed |
| 2017-03-10 09:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^] |
| 2017-03-10 11:45 | hgbot | Checkin | |
| 2017-03-10 11:45 | hgbot | Note Added: 0094906 | |
| 2017-03-10 13:00 | marvintm | Review Assigned To | => marvintm |
| 2017-03-10 13:00 | marvintm | Status | resolved => closed |
| 2017-03-10 13:00 | marvintm | Fixed in Version | => RR17Q2 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |