Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008500 | Openbravo ERP | 09. Financial management | public | 2009-04-08 10:41 | 2009-06-19 11:00 |
|
| Reporter | networkb | |
| Assigned To | dalsasua | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | unable to reproduce | |
| Platform | | OS | 30 | OS Version | |
| Product Version | 2.40MP3 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0008500: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows |
| Description | The 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 |
| Steps To Reproduce | |
| Proposed Solution | |
| Additional Information | |
| Tags | 250MP1 |
| Relationships | | depends on | backport | 0008594 | | closed | dalsasua | The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows |
|
| Attached Files | |
|
| 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 |
|
Notes |
|
|
(0016195)
|
|
hgbot
|
|
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
---
|
|
|
|
|
|
when check "select all" is selected, report is too slow. |
|
|
|
|
|
The product version is 2.40MP4 |
|
|
|
|
|
now, the response time of this report is correct |
|