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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023924
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementcriticalalways2013-05-27 18:322014-03-17 13:46
ReporteregoitzView Statuspublic 
Assigned ToSandrahuguet 
PriorityimmediateResolutionfixedFixed in Version3.0PR14Q2
StatusclosedFix in branchFixed in SCM revision12591b3385f8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toegoitz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023924: The c_invoice_create function takes long with big amount of data

DescriptionThe c_invoice_create function takes long with big amount of data.

'c_orderline';301054
'm_inout';66654
'm_inoutline';271216
'c_invoice';28805
'c_invoiceline';283204
'c_oder';75218
Steps To Reproduce-Create a product with invoice term inmediate and 10 lines
-complete it
-go to create invoices from order Form
-Select the order previously created
-Execute process
-It takes more than 5 seconds only for one order.

The problem seems to be caused by the select executed to define the Cur_InvoiceSchedule cursor.

The select is properly executed on pgadmin but on runtime it takes long due to the explain created with the parameters.

Check if the order by is needed because removing it reduces the time to finish the process

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0060786)
jonalegriaesarte (reporter)
2013-08-27 11:23

This processes (including book processes) are going to be reviewed in depth at the end of Q3-2013
(0064617)
hgbot (developer)
2014-02-26 15:34

Repository: erp/devel/pi
Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Feb 25 17:16:57 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^]

Fixes bug 23924 c_invoice_create takes long with big amount of data

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0064618)
hgbot (developer)
2014-02-26 15:34

Repository: erp/devel/pi
Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Feb 25 17:16:57 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^]

Fixes bug 23924 c_invoice_create takes long with big amount of data

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0064619)
hgbot (developer)
2014-02-26 15:34

Repository: erp/devel/pi
Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Feb 25 17:16:57 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^]

Fixes bug 23924 c_invoice_create takes long with big amount of data

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0064696)
hudsonbot (developer)
2014-02-28 19:50

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2a3305b1338e [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-05-27 18:32 egoitz New Issue
2013-05-27 18:32 egoitz Assigned To => dmiguelez
2013-05-27 18:32 egoitz Modules => Core
2013-05-27 18:32 egoitz Triggers an Emergency Pack => No
2013-05-28 10:20 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2013-08-27 11:23 jonalegriaesarte Note Added: 0060786
2013-08-27 11:23 jonalegriaesarte Type defect => design defect
2014-02-26 15:34 hgbot Checkin
2014-02-26 15:34 hgbot Note Added: 0064617
2014-02-26 15:34 hgbot Checkin
2014-02-26 15:34 hgbot Note Added: 0064618
2014-02-26 15:34 hgbot Checkin
2014-02-26 15:34 hgbot Note Added: 0064619
2014-02-26 15:34 hgbot Status new => resolved
2014-02-26 15:34 hgbot Resolution open => fixed
2014-02-26 15:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^]
2014-02-26 15:34 hgbot Status new => resolved
2014-02-26 15:34 hgbot Status new => resolved
2014-02-27 18:38 Sandrahuguet Assigned To jonalegriaesarte => Sandrahuguet
2014-02-28 19:50 hudsonbot Checkin
2014-02-28 19:50 hudsonbot Note Added: 0064696
2014-03-17 13:46 egoitz Review Assigned To => egoitz
2014-03-17 13:46 egoitz Status resolved => closed
2014-03-17 13:46 egoitz Fixed in Version => PR14Q2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker