Skip to content

Raise performance of K000 check

Dmitry requested to merge 421-dmius-k000-raise-performance into master

Description

As found during profiling the K000 check, code of generating separated files with query contributes to the main delay. In current PR

  • 2 calls of jq with full json replaced by one
  • calculation of query length and generating link moved to SQL code
  • code for generating unused readable_queryid variable remove.

As a result, we can see a rise in performance of K000 group of reports to 4 times with processing 500 queries. For example before:

[2019-07-15T21:59:09+0300] === Run on 'db2': ./resources/checks/K000_query_analysis.sh ===
[2019-07-15T22:03:25+0300] === End of running ===

after:

[2019-07-15T22:04:01+0300] === Run on 'db2': ./resources/checks/K000_query_analysis.sh ===
[2019-07-15T22:04:57+0300] === End of running ===

Related issue

#421 (closed)

Closes #421 (closed)

Edited by Anna

Merge request reports