Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005232Openbravo ERP07. Sales managementpublic2008-09-24 14:352009-04-21 11:05
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005232: '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.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, Sprint-1
Relationships
depends on backport 0005233 closed shuehner 'Sales Order' Selector does take a very long time to open with many sales orders 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-24 14:35shuehnerNew Issue
2008-09-24 14:35shuehnerAssigned To => shuehner
2008-09-24 14:35shuehnersf_bug_id0 => 2126322
2008-09-24 14:35shuehnerRegression testing => No
2008-09-24 14:36shuehnerStatusnew => scheduled
2008-09-24 14:36shuehnerfix_in_branch => trunk
2008-09-24 14:49svnbotCheckin
2008-09-24 14:49svnbotNote Added: 0009171
2008-09-24 14:49svnbotStatusscheduled => resolved
2008-09-24 14:49svnbotResolutionopen => fixed
2008-09-24 14:49svnbotsvn_revision => 7836
2008-09-24 15:07svnbotCheckin
2008-09-24 15:07svnbotNote Added: 0009172
2008-09-24 15:07svnbotsvn_revision7836 => 7842
2008-09-24 15:44shuehnerTag Attached: performance2.40scrum
2008-10-23 07:48iperdomoTag Attached: sprint1
2008-10-24 18:18iperdomoTag Detached: sprint1
2008-10-24 18:18iperdomoTag Attached: Sprint-1
2009-04-21 11:05psarobeStatusresolved => closed

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