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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008500
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-04-08 10:412009-06-19 11:00
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionunable to reproduceFixed in Version
StatusclosedFix in branchpiFixed in SCM revision0367d1bc28d1
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008500: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

DescriptionThe General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows. It takes long to print the report. It happens in oracle and postgres
Tags250MP1
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0008594 closeddalsasua The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows 

-  Notes
(0016195)
hgbot (developer)
2009-05-08 19:25

Repository: erp/devel/pi
Changeset: 0367d1bc28d12d89f8f5ed28dcf738e567f6575d
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri May 08 19:23:36 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0367d1bc28d12d89f8f5ed28dcf738e567f6575d [^]

Fixes Bug 8500: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0017346)
networkb (developer)
2009-06-16 13:15

when check "select all" is selected, report is too slow.
(0017347)
networkb (developer)
2009-06-16 13:18

The product version is 2.40MP4
(0017462)
networkb (developer)
2009-06-19 11:00

now, the response time of this report is correct

- Issue History
Date Modified Username Field Change
2009-04-08 10:41 networkb New Issue
2009-04-08 10:41 networkb Assigned To => rafaroda
2009-04-08 10:41 networkb Regression testing => No
2009-04-08 11:07 networkb Description Updated
2009-04-08 17:27 rafaroda Assigned To rafaroda => shuehner
2009-04-16 12:22 psarobe Status new => scheduled
2009-04-16 12:22 psarobe fix_in_branch => pi
2009-04-20 18:30 shuehner Assigned To shuehner => dalsasua
2009-04-23 16:05 psarobe Tag Attached: 250MP1
2009-05-08 19:25 hgbot Checkin
2009-05-08 19:25 hgbot Note Added: 0016195
2009-05-08 19:25 hgbot Status scheduled => resolved
2009-05-08 19:25 hgbot Resolution open => fixed
2009-05-08 19:25 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0367d1bc28d12d89f8f5ed28dcf738e567f6575d [^]
2009-06-03 19:34 psarobe Status resolved => closed
2009-06-03 19:34 psarobe Fixed in Version => 2.50MP2
2009-06-04 00:00 anonymous sf_bug_id 0 => 2800769
2009-06-16 13:15 networkb Status closed => new
2009-06-16 13:15 networkb Resolution fixed => open
2009-06-16 13:15 networkb Note Added: 0017346
2009-06-16 13:15 networkb Fixed in Version 2.50MP2 =>
2009-06-16 13:18 networkb Note Added: 0017347
2009-06-19 11:00 networkb Status new => closed
2009-06-19 11:00 networkb Note Added: 0017462
2009-06-19 11:00 networkb Resolution open => unable to reproduce


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker