Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010989Openbravo ERPA. Platformpublic2009-10-14 17:312009-11-10 11:24
Reporternetworkb 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP3 
Target Version2.40MP11Fixed in Version2.40MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010989: Time response of query generated by WAD is very high
DescriptionIn sales order window, in tab lines, the query generated by WAD to edit a record (selectEdit) is very slow when exists a lot of orders.
Steps To Reproduceenviroment with 20.000 orders and 200.000 order lines.
Sales Management || Transactions || Sales Order || Header >> Lines -> edit record
if you push "Go forward one record" button, the time to response is higher than 5 seconds
Proposed Solution
Additional Information
Tagsmain
Relationships
related to backport 0010718 closed shuehner org.openbravo.erpCommon.utility.ComboTableData performance issue on PostgreSQL 
related to defect 00114512.40MP12 closed shuehner Time response of query generated by WAD is very high 
related to backport 00115302.40MP12 closed shuehner Time response of query generated by WAD is very high 
blocks defect 00109682.40MP11 closed shuehner Time response of query generated by WAD is very high 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-15 16:33psarobeTypedefect => backport
2009-10-15 16:33psarobefix_in_branch => 2.40
2009-10-16 15:22shuehnerAssigned Torafaroda => shuehner
2009-10-16 15:24shuehnerNote Added: 0021117
2009-10-16 15:27shuehnerRelationship addedrelated to 0010718
2009-10-16 16:41hgbotCheckin
2009-10-16 16:41hgbotNote Added: 0021121
2009-10-16 16:41hgbotStatusscheduled => resolved
2009-10-16 16:41hgbotResolutionopen => fixed
2009-10-16 16:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/e09293c76905d8791f2e6e1a716a6aeb02401c75 [^]
2009-10-22 19:26psarobeTag Attached: main
2009-11-10 11:24arunkumarStatusresolved => closed
2009-11-10 11:24arunkumarNote Added: 0021677
2009-11-10 11:24arunkumarFixed in Version => 2.40MP11
2009-11-23 10:29shuehnerRelationship addedrelated to 0011451
2009-12-11 16:21shuehnerRelationship addedrelated to 0011530

Notes
(0021117)
shuehner   
2009-10-16 15:24   
Problem are missing to_number in some places which lead to bad execution plan without index use which hurts performance very much on bigger tables.
(0021121)
hgbot   
2009-10-16 16:41   
Repository: erp/stable/2.40
Changeset: e09293c76905d8791f2e6e1a716a6aeb02401c75
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Oct 16 16:40:36 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/e09293c76905d8791f2e6e1a716a6aeb02401c75 [^]

Fixed 10989: Improve query performance in wad windows
- Add missing to_number around numeric id-fields as otherwise postgres will
generate non-optimal query plans (without index usage)

---
M src-wad/src/org/openbravo/wad/Wad.java
M src-wad/src/org/openbravo/wad/datasource.xml
M src-wad/src/org/openbravo/wad/datasource.xsqlxml
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0021677)
arunkumar   
2009-11-10 11:24   
Tested & Working fine.