Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007443Openbravo ERPI. Performancepublic2009-02-06 09:272009-03-04 10:38
networkb 
shuehner 
immediatemajoralways
closedfixed 
5
2.40 
2.40MP3 
Core
No
0007443: Manufacturing processes very slow with large amount of data using PostgreSQL
Using PostgreSQL as database, if a Work Effort is created with several Production Runs and try to process it, the application gets slow.
Create a Work Effort and Production Runs (50, for instance). Try to complete it. The application runs so slow.
No tags attached.
blocks defect 0007405 closed shuehner Manufacturing processes very slow with large amount of data using PostgreSQL 
Issue History
2009-02-09 18:32shuehnerTypedefect => backport
2009-02-09 18:32shuehnerfix_in_branch => 2.40
2009-02-09 19:34svnbotCheckin
2009-02-09 19:34svnbotNote Added: 0013279
2009-02-09 19:34svnbotStatusscheduled => resolved
2009-02-09 19:34svnbotResolutionopen => fixed
2009-02-09 19:34svnbotsvn_revision => 12984
2009-03-03 17:32psarobeFixed in Version => 2.40MP3
2009-03-04 10:38psarobeStatusresolved => closed

Notes
(0013279)
svnbot   
2009-02-09 19:34   
Repository: openbravo
Revision: 12984
Author: huehner
Date: 2009-02-09 19:33:59 +0100 (Mon, 09 Feb 2009)

Fixed 7443
Add two missing indexes to speed up production

---
U branches/r2.40/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
U branches/r2.40/src-db/database/model/tables/M_COSTING.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12984&sc=1 [^]