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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009908
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2009-07-15 15:282009-07-23 00:00
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchpiFixed in SCM revisionbdfca44863ca
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

0009908: Business Partner Multiple selector is slow with many business partners

DescriptionThis selector is slow with many business partners (i.e. 50k -100k)
Tags250MP3releasecandidate, leo
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0009909 closedshuehner Business Partner Multiple selector is slow with many business partners 

-  Notes
(0018263)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-07-15 15:28 shuehner New Issue
2009-07-15 15:28 shuehner Assigned To => shuehner
2009-07-15 15:32 shuehner Status new => scheduled
2009-07-15 15:32 shuehner fix_in_branch => pi
2009-07-15 15:47 hgbot Checkin
2009-07-15 15:47 hgbot Note Added: 0018263
2009-07-15 15:47 hgbot Status scheduled => resolved
2009-07-15 15:47 hgbot Resolution open => fixed
2009-07-15 15:47 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bdfca44863ca0e10bf0fe74c874214aa21fceabd [^]
2009-07-21 16:24 psarobe Fixed in Version => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-21 18:43 psarobe Tag Attached: leo
2009-07-22 05:36 elopio Status resolved => closed
2009-07-23 00:00 anonymous sf_bug_id 0 => 2825618

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker