Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035267Retail ModulesWeb POSpublic2017-02-14 18:152017-04-06 18:01
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q2 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035267: Some indexes can be improved
DescriptionSome indexes in the Retail distribution and other modules affect columns which in many cases have a significant amount of null values.

These indexes could be improved so that only the not null records are included. This shouldn't impact the queries executed against these tables, and will significantly reduce the size of the index. The only downside is that the update to this release may be a bit slower due to some indexes having to be recreated.

More info can be found here: http://wiki.openbravo.com/wiki/Constraints_and_Triggers#Partial_indexes [^]
Steps To Reproduce.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate feature request 0035206 closed marvintm Openbravo ERP define partial indexes for not null values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-14 18:15marvintmNew Issue
2017-02-14 18:15marvintmAssigned To => marvintm
2017-02-14 18:15marvintmTriggers an Emergency Pack => No
2017-02-15 14:08hgbotCheckin
2017-02-15 14:08hgbotNote Added: 0094360
2017-02-15 14:08hgbotStatusnew => resolved
2017-02-15 14:08hgbotResolutionopen => fixed
2017-02-15 14:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^]
2017-02-15 14:08hgbotCheckin
2017-02-15 14:08hgbotNote Added: 0094361
2017-02-15 14:09hgbotCheckin
2017-02-15 14:09hgbotNote Added: 0094362
2017-02-15 14:09hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^]
2017-02-15 14:09hgbotCheckin
2017-02-15 14:09hgbotNote Added: 0094363
2017-02-15 14:09hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^]
2017-02-17 08:56hgbotCheckin
2017-02-17 08:56hgbotNote Added: 0094442
2017-02-17 08:56hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3 [^]
2017-03-06 13:21guilleaerReview Assigned To => guilleaer
2017-03-06 13:21guilleaerStatusresolved => closed
2017-03-06 13:21guilleaerFixed in Version => RR17Q2
2017-04-06 18:01marvintmDescription Updatedbug_revision_view_page.php?rev_id=14972#r14972
2017-04-06 18:01marvintmRelationship addedhas duplicate 0035206

Notes
(0094360)
hgbot   
2017-02-15 14:08   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: b8550e1aa9053f73f0b185f0e93ae23af22945e1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Feb 14 18:35:39 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^]

Fixed issue 35267. Transformed several indexes to be partial

---
M src-db/database/model/modifiedTables/C_IMPORT_ENTRY_ARCHIVE.xml
M src-db/database/model/modifiedTables/C_ORDER.xml
M src-db/database/model/modifiedTables/FIN_FINACC_TRANSACTION.xml
M src-db/database/model/tables/OBPOS_APPLICATIONS.xml
M src-db/database/model/tables/OBPOS_APP_CASHUP.xml
M src-db/database/model/tables/OBPOS_APP_PAYMENT.xml
M src-db/database/model/tables/OBPOS_TERMINALTYPE.xml
---
(0094361)
hgbot   
2017-02-15 14:08   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5afb363b4da539fee0d1e1125c48de49990851a1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Feb 15 11:01:00 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5afb363b4da539fee0d1e1125c48de49990851a1 [^]

Related to issue 35267. Changed back index in cashup parent column, as it was used for the master/slave cashup query.

---
M src-db/database/model/tables/OBPOS_APP_CASHUP.xml
---
(0094362)
hgbot   
2017-02-15 14:09   
Repository: erp/pmods/org.openbravo.retail.sessions
Changeset: a3770a9d60dab49d45b4601b68dd356de2520a72
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Feb 15 14:09:03 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^]

Fixed issue 35267. Transformed several indexes to be partial

---
M src-db/database/model/modifiedTables/OBPOS_APP_PAYMENT_TYPE.xml
---
(0094363)
hgbot   
2017-02-15 14:09   
Repository: erp/pmods/org.openbravo.mobile.warehouse
Changeset: 4716f87f08e505092ac710332e699d6c5582c53a
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Feb 15 14:09:31 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^]

Fixed issue 35267. Transformed several indexes to be partial

---
M src-db/database/model/tables/OBWH_MENU.xml
---
(0094442)
hgbot   
2017-02-17 08:56   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Feb 14 18:35:39 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3 [^]

Fixed issue 35267. Transformed several indexes to be partial

---
M src-db/database/model/tables/OBPOS_APP_CASHUP.xml
---