Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007405Openbravo ERPI. Performancepublic2009-02-06 09:272009-04-23 17:14
networkb 
shuehner 
immediatemajoralways
closedfixed 
5
2.40 
 
Core
No
0007405: 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.
main
depends on backport 0007443 closed shuehner Manufacturing processes very slow with large amount of data using PostgreSQL 
Issue History
2009-02-06 09:27networkbNew Issue
2009-02-06 09:27networkbAssigned To => rafaroda
2009-02-06 09:27networkbsf_bug_id0 => 2571707
2009-02-06 09:27networkbRegression testing => No
2009-02-06 10:33rafarodaAssigned Torafaroda => gorkaion
2009-02-06 14:46gorkaionDescription Updated
2009-02-06 14:46gorkaionProposed Solution updated
2009-02-09 09:35rafarodaversion => 2.40
2009-02-09 17:35shuehnerAssigned Togorkaion => shuehner
2009-02-09 18:32shuehnerStatusnew => scheduled
2009-02-09 18:32shuehnerfix_in_branch => trunk
2009-02-09 19:34svnbotCheckin
2009-02-09 19:34svnbotNote Added: 0013280
2009-02-09 19:34svnbotStatusscheduled => resolved
2009-02-09 19:34svnbotResolutionopen => fixed
2009-02-09 19:34svnbotsvn_revision => 12985
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 17:14psarobeStatusresolved => closed

Notes
(0013280)
svnbot   
2009-02-09 19:34   
Repository: openbravo
Revision: 12985
Author: huehner
Date: 2009-02-09 19:34:07 +0100 (Mon, 09 Feb 2009)

Fixed 7405
Add two missing indexes to speed up production

---
U trunk/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
U trunk/src-db/database/model/tables/M_COSTING.xml
---

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