Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009835Openbravo ERPA. Platformpublic2009-07-10 19:272009-07-13 13:37
shuehner 
shuehner 
normalminorhave not tried
closedfixed 
5
pi 
2.40MP7 
Core
No
0009835: Product selector is too slow on postgres with many products
The Product selector is too slow when used with many products. Tested on postgres with 100k products.
No tags attached.
blocks defect 0009834 closed shuehner Product selector is too slow on postgres with many products 
Issue History
2009-07-10 19:28shuehnerTypedefect => backport
2009-07-10 19:28shuehnerfix_in_branch => 2.40
2009-07-10 19:30hgbotCheckin
2009-07-10 19:30hgbotNote Added: 0018118
2009-07-10 19:30hgbotStatusscheduled => resolved
2009-07-10 19:30hgbotResolutionopen => fixed
2009-07-10 19:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/b97b65f28efbff54c03da3270efe18f785f1f893 [^]
2009-07-13 13:37psarobeStatusresolved => closed
2009-07-13 13:37psarobeFixed in Version => 2.40MP7

Notes
(0018118)
hgbot   
2009-07-10 19:30   
Repository: erp/stable/2.40
Changeset: b97b65f28efbff54c03da3270efe18f785f1f893
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Jul 10 19:30:39 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/b97b65f28efbff54c03da3270efe18f785f1f893 [^]

Fixed 9835: Optimize product selector performance on postgres
- removal of not needed joins in count query
- better placement of limit/offset so orderby + limit can be optimized by postgres

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