Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033652Openbravo ERP09. Financial managementpublic2016-08-04 08:452016-08-26 13:34
Reporterdmiguelez 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q2.2Fixed in Version3.0PR16Q2.2 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2016-02-16
Regression introduced in release3.0PR16Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/5435ecfe6c1f [^]
Triggers an Emergency PackNo
Summary0033652: Performance problems in Postgresql 9.3 when invoking view from query
DescriptionPerformance problems in Postgresql 9.3 when invoking view from query.

If this view is invoked from a Query in an environment with large volumes of data it can create performance problems in Postgresql 9.3 due to the Union in the view.
Steps To ReproduceIn an environment with large volumes of data, try to Post a Document (an Invoice for example). It takes a significant amount of time to post it.
Proposed SolutionMerge the View into one query removing the view.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0033620 closed dmiguelez Performance problems in Postgresql 9.3 when invoking view from query 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-08-08 14:35aferrazTypedefect => backport
2016-08-08 14:35aferrazTarget Version => 3.0PR16Q2.2
2016-08-08 15:05hgbotCheckin
2016-08-08 15:05hgbotNote Added: 0088900
2016-08-08 15:05hgbotStatusscheduled => resolved
2016-08-08 15:05hgbotResolutionopen => fixed
2016-08-08 15:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q2.2/rev/a4f023867f6be92409629efcda8701fe3025763c [^]
2016-08-08 15:06aferrazReview Assigned To => aferraz
2016-08-08 15:06aferrazNote Added: 0088901
2016-08-08 15:06aferrazStatusresolved => closed
2016-08-08 15:06aferrazFixed in Version => 3.0PR16Q2.2
2016-08-09 11:34hgbotCheckin
2016-08-09 11:34hgbotNote Added: 0088922
2016-08-26 13:20hgbotCheckin
2016-08-26 13:20hgbotNote Added: 0089452
2016-08-26 13:20hgbotStatusclosed => resolved
2016-08-26 13:20hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/backports/3.0PR16Q2.2/rev/a4f023867f6be92409629efcda8701fe3025763c [^] => http://code.openbravo.com/erp/devel/pi/rev/a4f023867f6be92409629efcda8701fe3025763c [^]
2016-08-26 13:20hgbotCheckin
2016-08-26 13:20hgbotNote Added: 0089453
2016-08-26 13:34priyamNote Added: 0089459
2016-08-26 13:34priyamStatusresolved => closed
2017-01-04 11:19jorge-garciaRelationship addedhas duplicate 0034815
2017-01-04 11:20jorge-garciaRelationship deletedhas duplicate 0034815

Notes
(0088900)
hgbot   
2016-08-08 15:05   
Repository: erp/backports/3.0PR16Q2.2
Changeset: a4f023867f6be92409629efcda8701fe3025763c
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Fri Aug 05 11:30:23 2016 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR16Q2.2/rev/a4f023867f6be92409629efcda8701fe3025763c [^]

Fixes issue 33652: Removes UNION ALL from view and merges it into one sentece

---
M src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
---
(0088901)
aferraz   
2016-08-08 15:06   
Code review OK
(0088922)
hgbot   
2016-08-09 11:34   
Repository: erp/backports/3.0PR16Q2.2
Changeset: e850e5212bc64cc888898628fed4aea6ca350e41
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Aug 09 11:30:20 2016 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR16Q2.2/rev/e850e5212bc64cc888898628fed4aea6ca350e41 [^]

Related to issue 33652: Remove parenthesis

---
M src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
---
(0089452)
hgbot   
2016-08-26 13:20   
Repository: erp/devel/pi
Changeset: a4f023867f6be92409629efcda8701fe3025763c
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Fri Aug 05 11:30:23 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a4f023867f6be92409629efcda8701fe3025763c [^]

Fixes issue 33652: Removes UNION ALL from view and merges it into one sentece

---
M src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
---
(0089453)
hgbot   
2016-08-26 13:20   
Repository: erp/devel/pi
Changeset: e850e5212bc64cc888898628fed4aea6ca350e41
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Aug 09 11:30:20 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e850e5212bc64cc888898628fed4aea6ca350e41 [^]

Related to issue 33652: Remove parenthesis

---
M src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
---
(0089459)
priyam   
2016-08-26 13:34   
Issues updated as int-promote updated pi with the tag changes of release 16Q2.2 before we merge the tag from main to pi. So the code hg-to-issues plugin updated the issues.

So closing the issue again