Project:
| View Revisions: Issue #39293 | [ Back to Issue ] | ||
| Summary | 0039293: Accounting Transaction Details Query Performance | ||
| Revision | 2018-09-14 13:18 by joniturralde93 | ||
| Steps To Reproduce | 1. Log into an environment with a lot of data. 2. Open Accounting Transaction Details Window. 3. It tooks for too long and you get a timeout. |
||
| Revision | 2018-09-14 13:18 by joniturralde93 | ||
| Description | We reproduced this is Metal-US test environment: Just load Accounting Transaction Details Window, the query is too slow and timeout is thrown. Attached query (with no filters) and Query plan (explain analyze). Same query in the database took 661 seconds. |
||
| Revision | 2018-09-14 13:16 by joniturralde93 | ||
| Steps To Reproduce | 1. Log into an environment with a lot of data. 2. Open Accounting Transaction Window. 3. It tooks for too long and you get a timeout. |
||
| Revision | 2018-09-14 13:16 by joniturralde93 | ||
| Description | We reproduced this is Metal-US test environment: Just load Accounting Transaction Window, the query is too slow and timeout is thrown. Attached query (with no filters) and Query plan (explain analyze). Same query in the database took 661 seconds. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |