Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009909Openbravo ERPA. Platformpublic2009-07-15 15:282009-07-22 13:28
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009909: Business Partner Multiple selector is slow with many business partners
DescriptionThis selector is slow with many business partners (i.e. 50k -100k)
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009908 closed shuehner Business Partner Multiple selector is slow with many business partners 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-15 15:32shuehnerTypedefect => backport
2009-07-15 15:32shuehnerfix_in_branch => 2.40
2009-07-17 15:23hgbotCheckin
2009-07-17 15:23hgbotNote Added: 0018374
2009-07-17 15:23hgbotStatusscheduled => resolved
2009-07-17 15:23hgbotResolutionopen => fixed
2009-07-17 15:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/011b8bbc6fd3dae4187d361bb60cb045e3850261 [^]
2009-07-22 13:28sureshbabuStatusresolved => closed
2009-07-22 13:28sureshbabuNote Added: 0018554
2009-07-22 13:28sureshbabuFixed in Version => 2.40MP8

Notes
(0018374)
hgbot   
2009-07-17 15:23   
Repository: erp/stable/2.40
Changeset: 011b8bbc6fd3dae4187d361bb60cb045e3850261
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jul 15 15:51:20 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/011b8bbc6fd3dae4187d361bb60cb045e3850261 [^]

Fixed 9909: Improve performance of the BusinessPartnerMultiple selector
- use select count(*) query for counting rows in current filter
- optimized placement of limit/offset & rownum on postgres/oracle
- refactor some unneeded coalesce in the query

---
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
---
(0018554)
sureshbabu   
2009-07-22 13:28   
Tested working fine