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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007405
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2009-02-06 09:272009-04-23 17:14
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision12985
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.2.3Ant version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007405: Manufacturing processes very slow with large amount of data using PostgreSQL

DescriptionUsing PostgreSQL as database, if a Work Effort is created with several Production Runs and try to process it, the application gets slow.
Steps To ReproduceCreate a Work Effort and Production Runs (50, for instance). Try to complete it. The application runs so slow.
Tagsmain
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0007443 closedshuehner Manufacturing processes very slow with large amount of data using PostgreSQL 

-  Notes
(0013280)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2009-02-06 09:27 networkb New Issue
2009-02-06 09:27 networkb Assigned To => rafaroda
2009-02-06 09:27 networkb sf_bug_id 0 => 2571707
2009-02-06 09:27 networkb Regression testing => No
2009-02-06 10:33 rafaroda Assigned To rafaroda => gorkaion
2009-02-06 14:46 gorkaion Description Updated
2009-02-06 14:46 gorkaion Proposed Solution updated
2009-02-09 09:35 rafaroda version => 2.40
2009-02-09 17:35 shuehner Assigned To gorkaion => shuehner
2009-02-09 18:32 shuehner Status new => scheduled
2009-02-09 18:32 shuehner fix_in_branch => trunk
2009-02-09 19:34 svnbot Checkin
2009-02-09 19:34 svnbot Note Added: 0013280
2009-02-09 19:34 svnbot Status scheduled => resolved
2009-02-09 19:34 svnbot Resolution open => fixed
2009-02-09 19:34 svnbot svn_revision => 12985
2009-04-22 11:24 psarobe Tag Attached: main
2009-04-23 17:14 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker