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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008594
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-04-08 10:412009-05-12 11:30
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.40MP4
StatusclosedFix in branch2.40Fixed in SCM revisiona6fd9ad6d550
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

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0008500 closeddalsasua The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows 

-  Notes
(0015977)
hgbot (developer)
2009-04-30 18:57

 Repository: erp/stable/2.40
Changeset: 947580d5ff20c594b3c4dc9554fac00291b8900a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Apr 30 18:55:07 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^]

Fixes Bug 8594: 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_data.xsql
---
(0016134)
hgbot (developer)
2009-05-07 13:16

 Repository: erp/stable/2.40
Changeset: f253a4e895cbed1785abe97f02013d0838c5f202
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu May 07 13:15:01 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^]

Fixes Bug 8594: 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
---
(0016169)
hgbot (developer)
2009-05-08 11:00

 Repository: erp/stable/2.40
Changeset: 9f335c8a4d1562e7ff0c7b6cbb171c8119be312d
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri May 08 11:00:34 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^]

Fixes Bug 8594: 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_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0016172)
hgbot (developer)
2009-05-08 12:16

 Repository: erp/stable/2.40
Changeset: 88199bb02706394a98895c788016dbfc16bea1e8
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri May 08 12:15:47 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^]

Fixes Bug 8594: 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_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0016268)
hgbot (developer)
2009-05-11 16:43

 Repository: erp/stable/2.40
Changeset: a6fd9ad6d5500da564975f897ea71b4d70e7d9aa
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon May 11 14:56:36 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/a6fd9ad6d5500da564975f897ea71b4d70e7d9aa [^]

Fixes Issue 8594: 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
---
(0016290)
psarobe (manager)
2009-05-12 11:30

 Not able to test it with so many rows

- Issue History
Date Modified Username Field Change
2009-04-16 12:22 psarobe Type defect => backport
2009-04-16 12:22 psarobe fix_in_branch => 2.40
2009-04-20 18:30 shuehner Assigned To shuehner => dalsasua
2009-04-30 18:57 hgbot Checkin
2009-04-30 18:57 hgbot Note Added: 0015977
2009-04-30 18:57 hgbot Status scheduled => resolved
2009-04-30 18:57 hgbot Resolution open => fixed
2009-04-30 18:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^]
2009-05-07 13:16 hgbot Checkin
2009-05-07 13:16 hgbot Note Added: 0016134
2009-05-07 13:16 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^] => http://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^]
2009-05-08 11:00 hgbot Checkin
2009-05-08 11:00 hgbot Note Added: 0016169
2009-05-08 11:00 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^] => http://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^]
2009-05-08 12:16 hgbot Checkin
2009-05-08 12:16 hgbot Note Added: 0016172
2009-05-08 12:16 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^] => http://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^]
2009-05-10 19:37 psarobe Fixed in Version => 2.40MP4
2009-05-11 16:43 hgbot Checkin
2009-05-11 16:43 hgbot Note Added: 0016268
2009-05-11 16:43 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^] => http://code.openbravo.com/erp/stable/2.40/rev/a6fd9ad6d5500da564975f897ea71b4d70e7d9aa [^]
2009-05-12 11:30 psarobe Status resolved => closed
2009-05-12 11:30 psarobe Note Added: 0016290

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker