Openbravo Issue Tracking System - Modules | |||||||||||||||||||||
| View Issue Details | |||||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||||
| 0030197 | Modules | Valued Stock Enhanced | public | 2015-06-17 10:30 | 2016-12-28 10:56 | ||||||||||||||||
| Reporter | ioritzCia | ||||||||||||||||||||
| Assigned To | psarobe | ||||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | always | ||||||||||||||||
| Status | closed | Resolution | duplicate | ||||||||||||||||||
| Platform | OS | 30 | OS Version | Ubuntu 14.04 | |||||||||||||||||
| Product Version | |||||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||||
| Merge Request Status | |||||||||||||||||||||
| Regression date | |||||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||||
| Regression level | |||||||||||||||||||||
| Review Assigned To | aferraz | ||||||||||||||||||||
| Support ticket | |||||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||||
| 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. | ||||||||||||||||||||
| Additional Information | |||||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||||
| Relationships |
| ||||||||||||||||||||
| Attached Files | |||||||||||||||||||||
| 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 | ||||||||||||||||||
| There are no notes attached to this issue. |