Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010968Openbravo ERPA. Platformpublic2009-10-14 17:312009-10-17 00:00
Reporternetworkb 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP3 
Target Version2.40MP11Fixed in Version 
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
Summary0010968: 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
TagsNo tags attached.
Relationships
depends on backport 00109892.40MP11 closed shuehner Time response of query generated by WAD is very high 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-14 17:31networkbNew Issue
2009-10-14 17:31networkbAssigned To => rafaroda
2009-10-14 17:31networkbOBNetwork customer => Yes
2009-10-14 17:33networkbNote Added: 0021009
2009-10-14 17:35shuehnerNote Added: 0021010
2009-10-14 17:37networkbNote Added: 0021011
2009-10-15 16:31psarobePriorityimmediate => high
2009-10-15 16:33psarobeStatusnew => scheduled
2009-10-15 16:33psarobeNote Added: 0021066
2009-10-15 16:33psarobeAssigned Torafaroda => shuehner
2009-10-15 16:33psarobefix_in_branch => pi
2009-10-16 15:23shuehnerStatusscheduled => closed
2009-10-16 15:23shuehnerNote Added: 0021116
2009-10-16 15:23shuehnerResolutionopen => no change required
2009-10-17 00:00anonymoussf_bug_id0 => 2880781

Notes
(0021009)
networkb   
2009-10-14 17:33   
we have sent to Stefan an enviroment with this problem.
(0021010)
shuehner   
2009-10-14 17:35   
Some first testing it seems that issue is missing to_number call around the _ID fields in wad-generated xsql files used for the selectEdit method of generated window. Additionally need to verify performance problem on latest MP9
(0021011)
networkb   
2009-10-14 17:37   
It is related to ticket 6049 in support portal
(0021066)
psarobe   
2009-10-15 16:33   
Hi Stefan,

If you think that the performance is good enough in MP9 or latest please reject the bug saying that it's fixed in MP9 or later
(0021116)
shuehner   
2009-10-16 15:23   
The issue only exists on 2.40 with postgres. Rejecting the defect as not changes is required on pi. The 2.40 issue is tracked as backport 10989.