Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009908Openbravo ERPA. Platformpublic2009-07-15 15:282009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
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
Summary0009908: 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
Tags250MP3releasecandidate, leo
Relationships
depends on backport 0009909 closed shuehner Business Partner Multiple selector is slow with many business partners 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-15 15:28shuehnerNew Issue
2009-07-15 15:28shuehnerAssigned To => shuehner
2009-07-15 15:32shuehnerStatusnew => scheduled
2009-07-15 15:32shuehnerfix_in_branch => pi
2009-07-15 15:47hgbotCheckin
2009-07-15 15:47hgbotNote Added: 0018263
2009-07-15 15:47hgbotStatusscheduled => resolved
2009-07-15 15:47hgbotResolutionopen => fixed
2009-07-15 15:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bdfca44863ca0e10bf0fe74c874214aa21fceabd [^]
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 05:36elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825618

Notes
(0018263)
hgbot   
2009-07-15 15:47   
Repository: erp/devel/pi
Changeset: bdfca44863ca0e10bf0fe74c874214aa21fceabd
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jul 15 15:47:31 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bdfca44863ca0e10bf0fe74c874214aa21fceabd [^]

Fixed 9908: Improve performance of 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
---