{"id":570,"date":"2020-09-30T11:05:54","date_gmt":"2020-09-30T08:05:54","guid":{"rendered":"https:\/\/www.drinkits.lv\/?p=570"},"modified":"2020-11-23T11:40:11","modified_gmt":"2020-11-23T09:40:11","slug":"favourite-filters-issue-count-performance-problems-in-large-instances","status":"publish","type":"post","link":"https:\/\/www.drinkits.lv\/en\/2020\/09\/30\/favourite-filters-issue-count-performance-problems-in-large-instances\/","title":{"rendered":"Favourite Filters Issue Count Performance problems in large instances (Jira)"},"content":{"rendered":"

As described in this Atlassian ticket<\/a> there may be performance problems using Favourite Filters gadget in large Jira instances.<\/p>\n

\n

In our Jira instance (>2m issues, >10k users) these favfilters?showCounts=true <\/em>requests where very expensive to CPU load.<\/p>\n<\/div>\n

\"\"<\/a><\/p>\n

In Atlassian ticket there is workaround provided how to turn off this feature in proxy level, but what to do if no proxy is used in front of Jira?<\/p>\n

In our case we used Tuckey UrlRewriteFilter<\/a> which is built in Jira by default. Open \/jira_install_dir\/atlassian-jira\/WEB-INF\/urlrewrite.xml <\/em>and add this code before closing <\/urlrewrite><\/em> tag:<\/p>\n

\n
<rule enabled=\"true\">\r\n    <name>Disables Favourite Filters Issue Count<\/name>\r\n    <condition type=\"parameter\" name=\"showCounts\" operator=\"equal\">true<\/condition>\r\n    <from>^\/rest\/gadget\/1.0\/favfilters<\/from>\r\n    <to type=\"permanent-redirect\">\/rest\/gadget\/1.0\/favfilters?showCounts=false<\/to>\r\n<\/rule><\/pre>\n
\"\"<\/a>After Jira restart users will see “UNDEFINED” result if they turn on Issue Count functionality.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"
As described in this Atlassian ticket there may be performance problems using Favourite Filters gadget in large Jira instances. In our Jira instance (>2m issues, >10k users) these favfilters?showCounts=true requests where very expensive to CPU load. In Atlassian ticket there is workaround provided how to turn off this feature in proxy level, but what to […]<\/p>\n<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7,8],"tags":[47,90,112,114,113],"class_list":{"0":"post-570","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-noderigi","7":"category-skripti","8":"tag-jira","9":"tag-script","10":"tag-tuckey","11":"tag-urlrewrite-xml","12":"tag-urlrewritefilter","13":"h-entry","14":"hentry"},"_links":{"self":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts\/570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/comments?post=570"}],"version-history":[{"count":14,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts\/570\/revisions"}],"predecessor-version":[{"id":592,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts\/570\/revisions\/592"}],"wp:attachment":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/media?parent=570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/categories?post=570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/tags?post=570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}