Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011530Openbravo ERPA. Platformpublic2009-11-20 20:322010-01-27 13:23
Reporternetworkb 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.40MP10 
Target Version2.40MP12Fixed in Version2.50MP12 
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
Summary0011530: Time response of query generated by WAD is very high
DescriptionIn goodshipments window, in tab lines, the query generated by WAD to create a new record (set) is very slow when exists a lot of shipments.
Steps To Reproduceenviroment with 20.000 shipments and 200.000 shipments lines.
Sales Management || Transactions || Goods Shipment || Header >> Lines ->
  edit line and click "save and new" button
the time to response is higher than 6 seconds
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00109892.40MP11 closed shuehner Time response of query generated by WAD is very high 
related to defect 0010318 closed shuehner Big performance issue on PostgreSQL with large table data 
blocks defect 00114512.40MP12 closed shuehner Time response of query generated by WAD is very high 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-27 15:21rafarodaTypedefect => backport
2009-11-27 15:21rafarodafix_in_branch => 2.40
2009-12-11 16:21shuehnerRelationship addedrelated to 0010989
2009-12-14 14:34shuehnerRelationship addedrelated to 0011752
2009-12-14 22:05shuehnerRelationship addedrelated to 0010318
2009-12-14 22:05shuehnerRelationship deletedrelated to 0011752
2009-12-14 22:11hgbotCheckin
2009-12-14 22:11hgbotNote Added: 0022776
2009-12-14 22:11hgbotStatusscheduled => resolved
2009-12-14 22:11hgbotResolutionopen => fixed
2009-12-14 22:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/5f068d028361dd6ed8e85d918202aff826dc2d62 [^]
2010-01-27 13:23arunkumarNote Added: 0023825
2010-01-27 13:23arunkumarStatusresolved => closed
2010-01-27 13:23arunkumarFixed in Version => 2.50MP12

Notes
(0022776)
hgbot   
2009-12-14 22:11   
Repository: erp/stable/2.40
Changeset: 5f068d028361dd6ed8e85d918202aff826dc2d62
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Dec 14 22:08:14 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/5f068d028361dd6ed8e85d918202aff826dc2d62 [^]

Fixed 11530: Optimize perfomance of wad windows on postgresql >=8.3
By adding missing to_number to sql code in defaultvalue column

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0023825)
arunkumar   
2010-01-27 13:23   
Tested & Working fine