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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009909
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorhave not tried2009-07-15 15:282009-07-22 13:28
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.40MP8
StatusclosedFix in branch2.40Fixed in SCM revision011b8bbc6fd3
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

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

DescriptionThis selector is slow with many business partners (i.e. 50k -100k)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0009908 closedshuehner Business Partner Multiple selector is slow with many business partners 

-  Notes
(0018374)
hgbot (developer)
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 (reporter)
2009-07-22 13:28

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-07-15 15:32 shuehner Type defect => backport
2009-07-15 15:32 shuehner fix_in_branch => 2.40
2009-07-17 15:23 hgbot Checkin
2009-07-17 15:23 hgbot Note Added: 0018374
2009-07-17 15:23 hgbot Status scheduled => resolved
2009-07-17 15:23 hgbot Resolution open => fixed
2009-07-17 15:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/011b8bbc6fd3dae4187d361bb60cb045e3850261 [^]
2009-07-22 13:28 sureshbabu Status resolved => closed
2009-07-22 13:28 sureshbabu Note Added: 0018554
2009-07-22 13:28 sureshbabu Fixed in Version => 2.40MP8

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker