Openbravo Issue Tracking System - Localization Pack: Spain |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0023106 | Localization Pack: Spain | AEAT 347 | public | 2013-02-18 18:00 | 2017-05-29 15:20 |
|
| Reporter | egoitz | |
| Assigned To | Triage Finance | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0023106: The 347 report takes more than 30 minutes to get data for a year on an environment with a big fact_act |
| Description | The 347 report takes more than 30 minutes to get data for a year on an environment with a big fact_act.
In this case the fact_act table has 5899791 rows |
| Steps To Reproduce | -Execute the 347 report on an environment with 5899791 ows on the fact_acct table |
| Proposed Solution | Test with the following index:
CREATE INDEX Fact_Acct_C_Tax_ID ON Fact_Acct(C_Tax_ID); |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-02-18 18:00 | egoitz | New Issue | |
| 2013-02-18 18:00 | egoitz | Assigned To | => jonalegriaesarte |
| 2013-02-18 18:17 | egoitz | Assigned To | jonalegriaesarte => Sandrahuguet |
| 2013-02-18 18:33 | egoitz | Proposed Solution updated | |
| 2013-02-25 10:58 | Sandrahuguet | Priority | immediate => high |
| 2013-03-04 17:08 | psanjuan | Note Added: 0057014 | |
| 2013-03-04 17:08 | psanjuan | Type | defect => design defect |
| 2015-03-17 09:40 | apalacios | Issue Monitored: apalacios | |
| 2017-05-29 15:20 | Sandrahuguet | Assigned To | Sandrahuguet => Triage Finance |