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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011530
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajoralways2009-11-20 20:322010-01-27 13:23
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branch2.40Fixed in SCM revision5f068d028361
ProjectionnoneETAnoneTarget Version2.40MP12
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_16
OS VersionCommunity ApplianceDatabase version8.3.8Ant version1.7.1
Product Version2.40MP10SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011530: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 00109892.40MP11 closedshuehner Time response of query generated by WAD is very high 
related to defect 0010318 closedshuehner Big performance issue on PostgreSQL with large table data 
blocks defect 00114512.40MP12 closedshuehner Time response of query generated by WAD is very high 

-  Notes
(0022776)
hgbot (developer)
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 (reporter)
2010-01-27 13:23

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-11-27 15:21 rafaroda Type defect => backport
2009-11-27 15:21 rafaroda fix_in_branch => 2.40
2009-12-11 16:21 shuehner Relationship added related to 0010989
2009-12-14 14:34 shuehner Relationship added related to 0011752
2009-12-14 22:05 shuehner Relationship added related to 0010318
2009-12-14 22:05 shuehner Relationship deleted related to 0011752
2009-12-14 22:11 hgbot Checkin
2009-12-14 22:11 hgbot Note Added: 0022776
2009-12-14 22:11 hgbot Status scheduled => resolved
2009-12-14 22:11 hgbot Resolution open => fixed
2009-12-14 22:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/5f068d028361dd6ed8e85d918202aff826dc2d62 [^]
2010-01-27 13:23 arunkumar Note Added: 0023825
2010-01-27 13:23 arunkumar Status resolved => closed
2010-01-27 13:23 arunkumar Fixed in Version => 2.50MP12

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker