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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005232
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminorN/A2008-09-24 14:352009-04-21 11:05
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7842
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005232: 'Sales Order' Selector does take a very long time to open with many sales orders

DescriptionThis selector takes a long time to open or update when a lot of sales orders exist in the database.
Tagsperformance2.40scrum, Sprint-1
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0005233 closedshuehner 'Sales Order' Selector does take a very long time to open with many sales orders 

-  Notes
(0009171)
svnbot (reporter)
2008-09-24 14:49

Repository: openbravo
Revision: 7836
Author: huehner
Date: 2008-09-24 14:49:15 +0200 (Wed, 24 Sep 2008)

Fixed 5232
Improve Performance of the Sales Order selector:
- use faster query to count sales orders in filter
- optimize query for getting the data
- disable sorting by column converted (feature regression!)

---
U trunk/src/org/openbravo/erpCommon/info/SalesOrder.java
U trunk/src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7836&sc=1 [^]
(0009172)
svnbot (reporter)
2008-09-24 15:07

Repository: openbravo
Revision: 7842
Author: huehner
Date: 2008-09-24 15:06:57 +0200 (Wed, 24 Sep 2008)

Issue 5232
Remove unneeded order by introduced in last commit which gives error on postgresql

---
U trunk/src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
---

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

- Issue History
Date Modified Username Field Change
2008-09-24 14:35 shuehner New Issue
2008-09-24 14:35 shuehner Assigned To => shuehner
2008-09-24 14:35 shuehner sf_bug_id 0 => 2126322
2008-09-24 14:35 shuehner Regression testing => No
2008-09-24 14:36 shuehner Status new => scheduled
2008-09-24 14:36 shuehner fix_in_branch => trunk
2008-09-24 14:49 svnbot Checkin
2008-09-24 14:49 svnbot Note Added: 0009171
2008-09-24 14:49 svnbot Status scheduled => resolved
2008-09-24 14:49 svnbot Resolution open => fixed
2008-09-24 14:49 svnbot svn_revision => 7836
2008-09-24 15:07 svnbot Checkin
2008-09-24 15:07 svnbot Note Added: 0009172
2008-09-24 15:07 svnbot svn_revision 7836 => 7842
2008-09-24 15:44 shuehner Tag Attached: performance2.40scrum
2008-10-23 07:48 iperdomo Tag Attached: sprint1
2008-10-24 18:18 iperdomo Tag Detached: sprint1
2008-10-24 18:18 iperdomo Tag Attached: Sprint-1
2009-04-21 11:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker