Project:
| View Revisions: Issue #42269 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0042269: [Performance] ProductCharacteristicValue master data performance improvement | ||
| Revision | 2019-11-13 13:05 by ioritzCia | ||
| Steps To Reproduce | Set log min duration statement of the environment accordingly (typically < 200ms) to be able to see both executions in log. Log in WebPOS and check for the execution of the query Original query example: https://pastebin.com/16RFjMdi [^] Changed query example: https://pastebin.com/8ZPUFBwk [^] Plan before the change: https://explain.depesz.com/s/IO5k [^] Plan after the change: https://explain.depesz.com/s/sps9 [^] |
||
| Revision | 2019-11-13 12:59 by ioritzCia | ||
| Steps To Reproduce | Log in WebPOS and check for the execution of the query Original query example: https://pastebin.com/16RFjMdi [^] Plan before the change: https://explain.depesz.com/s/IO5k [^] Plan after the change: https://explain.depesz.com/s/sps9 [^] |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |