{"id":4405,"date":"2016-02-15T13:11:21","date_gmt":"2016-02-15T13:11:21","guid":{"rendered":"http:\/\/blog.soton.ac.uk\/servicemanagement\/?p=4405"},"modified":"2016-02-15T13:11:21","modified_gmt":"2016-02-15T13:11:21","slug":"row-limitation","status":"publish","type":"post","link":"https:\/\/blog.soton.ac.uk\/servicemanagement\/2016\/02\/15\/row-limitation\/","title":{"rendered":"Row Limitation"},"content":{"rendered":"<p>Following reports of performance issues within the system, it has been recommended by ServiceNow that we limit the amount of rows people can set when looking at lists.\u00a0 The recommended (and default) number of rows is 20 and the maximum out of the box limit is 100.\u00a0 As part of the implementation, our maximum was adjusted to 500.\u00a0 However, this goes against the best practise recommendations set by ServiceNow.\u00a0 Returning a 500 item list will take at least five times longer than returning the default maximum of 100, which itself can take a few seconds.\u00a0 As lists can be presented within certain forms, this can have a negative performance impact throughout the system.<\/p>\n<p>We are implementing a change that sets the maximum available row count to 75.\u00a0 This is below the recommended maximum in order for us to monitor performance following the change and understand if this makes the improvements ServiceNow expect, or if the performance issues lie in other areas.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-4406\" src=\"http:\/\/blog.soton.ac.uk\/servicemanagement\/files\/2016\/02\/Row-Count.jpg\" alt=\"Row Count\" width=\"211\" height=\"174\" \/><\/p>\n<p>Details about how these settings can impact performance and best practise recommendations can be found at the following links:<\/p>\n<p><a href=\"http:\/\/wiki.servicenow.com\/index.php?title=System_Performance_Best_Practices#Default_Row_Count&amp;gsc.tab=0\">ServiceNow System Performance Best Practice<\/a><\/p>\n<p><a href=\"https:\/\/community.servicenow.com\/community\/blogs\/blog\/2014\/12\/03\/displaying-just-enough-data-helps-performance\">ServiceNow Data Display and Performance<\/a><\/p>\n<div id=\"themify_builder_content-4405\" data-postid=\"4405\" class=\"themify_builder_content themify_builder_content-4405 themify_builder themify_builder_front\">\n\t\t<\/div>\n<!-- \/themify_builder_content -->","protected":false},"excerpt":{"rendered":"<p>Following reports of performance issues within the system, it has been recommended by ServiceNow that we limit the amount of rows people can set when looking at lists.\u00a0 The recommended (and default) number of rows is 20 and the maximum out of the box limit is 100.\u00a0 As part of the implementation, our maximum was [&hellip;]<\/p>\n","protected":false},"author":97582,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4405","post","type-post","status-publish","format-standard","hentry","category-uncategorized","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author"],"_links":{"self":[{"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/posts\/4405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/users\/97582"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/comments?post=4405"}],"version-history":[{"count":2,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/posts\/4405\/revisions"}],"predecessor-version":[{"id":4409,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/posts\/4405\/revisions\/4409"}],"wp:attachment":[{"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/media?parent=4405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/categories?post=4405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/servicemanagement\/wp-json\/wp\/v2\/tags?post=4405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}