Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009563Openbravo ERPA. Platformpublic2009-06-19 14:092009-07-10 10:49
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP7 
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
Summary0009563: 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
blocks feature request 0009562 closed shuehner Optimize Product selector on oracle to be faster with many products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-19 14:10shuehnerTypefeature request => backport
2009-06-19 14:10shuehnerfix_in_branch => 2.40
2009-06-24 16:35hgbotCheckin
2009-06-24 16:35hgbotNote Added: 0017565
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/stable/2.40/rev/247f167a2384fabf0bf7f42829b3a8a3f7321c1f [^]
2009-07-10 10:49sureshbabuStatusresolved => closed
2009-07-10 10:49sureshbabuNote Added: 0018086
2009-07-10 10:49sureshbabuFixed in Version => 2.40MP7

Notes
(0017565)
hgbot   
2009-06-24 16:35   
Repository: erp/stable/2.40
Changeset: 247f167a2384fabf0bf7f42829b3a8a3f7321c1f
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jun 24 16:34:47 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/247f167a2384fabf0bf7f42829b3a8a3f7321c1f [^]

Fixed 9563: 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
---
(0018086)
sureshbabu   
2009-07-10 10:49   
Tested working fine