Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0023106 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Localization Pack: Spain] AEAT 347 | major | always | 2013-02-18 18:00 | 2017-05-29 15:20 | |||||||
| Reporter | egoitz | View Status | public | |||||||||
| Assigned To | Triage Finance | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Oracle | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Regression date | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Regression level | ||||||||||||
| Review Assigned To | ||||||||||||
| 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); | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0057014) psanjuan (manager) 2013-03-04 17:08 |
Changed to design defect as this is something which requires research. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |