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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009562
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2009-06-19 14:092009-08-11 00:00
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchpiFixed in SCM revisioncc9c20208b2e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009562: Optimize Product selector on oracle to be faster with many products

DescriptionWhen having about 1 million products in the db the product selector is not usable as it is to slow.
Steps To ReproduceUse a test database with a huge number of products
Open the product selector
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0009563 closedshuehner Optimize Product selector on oracle to be faster with many products 

-  Notes
(0017566)
hgbot (developer)
2009-06-24 16:35

Repository: erp/devel/pi
Changeset: cc9c20208b2ea2dfebe9a30168e90254cde818e7
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jun 24 16:34:46 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cc9c20208b2ea2dfebe9a30168e90254cde818e7 [^]

Fixed 9562: Optimize product selector on oracle by better placement of the rownum where clause

---
M src/org/openbravo/erpCommon/info/Product.java
M src/org/openbravo/erpCommon/info/Product_data.xsql
---

- Issue History
Date Modified Username Field Change
2009-06-19 14:09 shuehner New Issue
2009-06-19 14:09 shuehner Assigned To => shuehner
2009-06-19 14:10 shuehner Status new => scheduled
2009-06-19 14:10 shuehner fix_in_branch => pi
2009-06-24 16:35 hgbot Checkin
2009-06-24 16:35 hgbot Note Added: 0017566
2009-06-24 16:35 hgbot Status scheduled => resolved
2009-06-24 16:35 hgbot Resolution open => fixed
2009-06-24 16:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc9c20208b2ea2dfebe9a30168e90254cde818e7 [^]
2009-08-10 22:32 pjuvara Status resolved => closed
2009-08-10 22:32 pjuvara Fixed in Version => 2.50MP3
2009-08-11 00:00 anonymous sf_bug_id 0 => 2835188


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker