Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035267
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminoralways2017-02-14 18:152017-04-06 18:01
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in VersionRR17Q2
StatusclosedFix in branchFixed in SCM revisionbb32e2fbd564
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toguilleaer
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035267: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate feature request 0035206 closedmarvintm Openbravo ERP define partial indexes for not null values 

-  Notes
(0094360)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2017-02-14 18:15 marvintm New Issue
2017-02-14 18:15 marvintm Assigned To => marvintm
2017-02-14 18:15 marvintm Triggers an Emergency Pack => No
2017-02-15 14:08 hgbot Checkin
2017-02-15 14:08 hgbot Note Added: 0094360
2017-02-15 14:08 hgbot Status new => resolved
2017-02-15 14:08 hgbot Resolution open => fixed
2017-02-15 14:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^]
2017-02-15 14:08 hgbot Checkin
2017-02-15 14:08 hgbot Note Added: 0094361
2017-02-15 14:09 hgbot Checkin
2017-02-15 14:09 hgbot Note Added: 0094362
2017-02-15 14:09 hgbot Fixed in SCM revision http://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:09 hgbot Checkin
2017-02-15 14:09 hgbot Note Added: 0094363
2017-02-15 14:09 hgbot Fixed in SCM revision http://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:56 hgbot Checkin
2017-02-17 08:56 hgbot Note Added: 0094442
2017-02-17 08:56 hgbot Fixed in SCM revision http://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:21 guilleaer Review Assigned To => guilleaer
2017-03-06 13:21 guilleaer Status resolved => closed
2017-03-06 13:21 guilleaer Fixed in Version => RR17Q2
2017-04-06 18:01 marvintm Description Updated View Revisions
2017-04-06 18:01 marvintm Relationship added has duplicate 0035206


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker