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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010989
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajoralways2009-10-14 17:312009-11-10 11:24
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Version2.40MP11
StatusclosedFix in branch2.40Fixed in SCM revisione09293c76905
ProjectionnoneETAnoneTarget Version2.40MP11
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40MP3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010989: 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
Tagsmain
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 0010718 closedshuehner org.openbravo.erpCommon.utility.ComboTableData performance issue on PostgreSQL 
related to defect 00114512.40MP12 closedshuehner Time response of query generated by WAD is very high 
related to backport 00115302.40MP12 closedshuehner Time response of query generated by WAD is very high 
blocks defect 00109682.40MP11 closedshuehner Time response of query generated by WAD is very high 

-  Notes
(0021117)
shuehner (administrator)
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 (developer)
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 (viewer)
2009-11-10 11:24

 Tested & Working fine.

- Issue History
Date Modified Username Field Change
2009-10-15 16:33 psarobe Type defect => backport
2009-10-15 16:33 psarobe fix_in_branch => 2.40
2009-10-16 15:22 shuehner Assigned To rafaroda => shuehner
2009-10-16 15:24 shuehner Note Added: 0021117
2009-10-16 15:27 shuehner Relationship added related to 0010718
2009-10-16 16:41 hgbot Checkin
2009-10-16 16:41 hgbot Note Added: 0021121
2009-10-16 16:41 hgbot Status scheduled => resolved
2009-10-16 16:41 hgbot Resolution open => fixed
2009-10-16 16:41 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/e09293c76905d8791f2e6e1a716a6aeb02401c75 [^]
2009-10-22 19:26 psarobe Tag Attached: main
2009-11-10 11:24 arunkumar Status resolved => closed
2009-11-10 11:24 arunkumar Note Added: 0021677
2009-11-10 11:24 arunkumar Fixed in Version => 2.40MP11
2009-11-23 10:29 shuehner Relationship added related to 0011451
2009-12-11 16:21 shuehner Relationship added related to 0011530

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker