Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0030197 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Valued Stock Enhanced | major | always | 2015-06-17 10:30 | 2016-12-28 10:56 | |||
| Reporter | ioritzCia | View Status | public | |||||
| Assigned To | psarobe | |||||||
| Priority | high | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 6 | |||
| OS Version | Ubuntu 14.04 | Database version | 9.3 | Ant version | ||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | aferraz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0030197: Enhanced valued stock report's performance is bad when no warehouse is filtered. | |||||||
| Description | Enhanced valued stock report takes too long (12 min for example) if no warehouse is specified on the filters. The query is quite old and complex and should be refactored. Appart from refactoring it to work better, while improving it, it may now take the advantage of cost being in m_transaction table (it was not before). You can go here http://explain.depesz.com/s/lZpm [^] to see an explain of the query. Takes too long to join m_inoutline and m_transaction tables, row 10 on the explain. We have a clone of an instance where this can be reproduced. Note: There is a collaborative development called Consolidation of stock pending to be accepted for 15PRQ4, this should also be reviewed. | |||||||
| Steps To Reproduce | - Go to Enhanced Valued Stock Report in an instance with lots of transactions. - Launch the report without warehouse filter. | |||||||
| Proposed Solution | Refactor the query. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||
|
|||||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-06-17 10:30 | ioritzCia | New Issue | |
| 2015-06-17 10:30 | ioritzCia | Assigned To | => jonalegriaesarte |
| 2015-06-18 09:51 | egoitz | Resolution time | => 1437343200 |
| 2015-06-22 13:06 | jpcalvente | Issue Monitored: jpcalvente | |
| 2015-06-22 13:34 | VictorVillar | Assigned To | jonalegriaesarte => Triage Finance |
| 2015-06-26 14:49 | VictorVillar | Assigned To | Triage Finance => psarobe |
| 2016-01-13 16:59 | dmiguelez | Relationship added | related to 0031874 |
| 2016-04-22 14:41 | ngarcia | Issue Monitored: ngarcia | |
| 2016-12-28 10:56 | aferraz | Review Assigned To | => aferraz |
| 2016-12-28 10:56 | aferraz | Relationship added | duplicate of 0034482 |
| 2016-12-28 10:56 | aferraz | Status | new => closed |
| 2016-12-28 10:56 | aferraz | Resolution | open => duplicate |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |