Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009562Openbravo ERPA. Platformpublic2009-06-19 14:092009-08-11 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP3 
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
Summary0009562: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0009563 closed shuehner Optimize Product selector on oracle to be faster with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-19 14:09shuehnerNew Issue
2009-06-19 14:09shuehnerAssigned To => shuehner
2009-06-19 14:09shuehnerOBNetwork customer => No
2009-06-19 14:10shuehnerStatusnew => scheduled
2009-06-19 14:10shuehnerfix_in_branch => pi
2009-06-24 16:35hgbotCheckin
2009-06-24 16:35hgbotNote Added: 0017566
2009-06-24 16:35hgbotStatusscheduled => resolved
2009-06-24 16:35hgbotResolutionopen => fixed
2009-06-24 16:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc9c20208b2ea2dfebe9a30168e90254cde818e7 [^]
2009-08-10 22:32pjuvaraStatusresolved => closed
2009-08-10 22:32pjuvaraFixed in Version => 2.50MP3
2009-08-11 00:00anonymoussf_bug_id0 => 2835188

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