{"id":42173,"date":"2018-12-05T14:24:59","date_gmt":"2018-12-05T06:24:59","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=42173"},"modified":"2020-11-11T17:46:33","modified_gmt":"2020-11-11T09:46:33","slug":"performance-considerations-in-data-windowing","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/sentinel-studio-primers\/performance-considerations-in-data-windowing\/","title":{"rendered":"Performance Considerations in Data Windowing"},"content":{"rendered":"\n<p class=\"intro-text\">There may sometimes be several ways of achieving the same result when obtaining a data point; however, whenever you retrieve a window of data, you should be aware of potential performance issues. The more data points that you retrieve, the slower your process will run.<\/p>\n<p class=\"intro-text\">For example, the following two processes both do the same thing: they compare the first and last value of a given time period.<\/p>\n<p class=\"intro-text\"><strong>Process 1<\/strong><\/p>\n<p class=\"intro-text\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-43026 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27.png\" alt=\"\" width=\"850\" height=\"139\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27.png 850w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27-768x126.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27-150x25.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27-24x4.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27-36x6.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-27-48x8.png 48w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p class=\"intro-text\">Process 1 is a visually simple representation of this process. It retrieves a 24-hour window of data, gets the first value of that window, and then compares it with the current value.<\/p>\n<p class=\"intro-text\">\n<img loading=\"lazy\" decoding=\"async\" width=\"525\" height=\"213\" class=\"wp-image-43027\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28.png\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28.png 525w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28-150x61.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28-36x15.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-28-48x19.png 48w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p class=\"intro-text\"><strong>Process 2<\/strong><\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-43028 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29.png\" alt=\"\" width=\"1126\" height=\"223\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29.png 1126w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29-768x152.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29-150x30.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29-36x7.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-29-48x10.png 48w\" sizes=\"auto, (max-width: 1126px) 100vw, 1126px\" \/><\/a><\/p>\n<p class=\"intro-text\">Process 2 is more complicated. Rather than retrieving the entire 24-hour period of data, it only retrieves data for the minute before the start of that time period. It then takes the last value of that minute of data, and compares it with the current value.<\/p>\n<p class=\"intro-text\">\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-43029 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30.png\" alt=\"\" width=\"539\" height=\"279\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30.png 539w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30-150x78.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/12\/word-image-30-48x25.png 48w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<p class=\"intro-text\">Even though Process 2 appears to be more complicated than Process 1, it is in fact faster as it retrieves fewer data points.<\/p>\n<p class=\"left-bar\">Related: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/sentinel-studio-primers\/\">Sentinel Studio Primers<\/a>,\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/creating-user-processes\/creating-a-new-user-process\/\">Creating a User Process<\/a>, <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/component-logic-functions\/data\/\">Data Functions<\/a>, <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/component-logic-functions\/data-set\/\">Data Set Functions<\/a>, <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/usage-examples\/\">Usage Examples<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There may sometimes be several ways of achieving the same result when obtaining a data point; however, whenever you retrieve a window of data using Sentinel Studio, you should be aware of potential performance issues. The more data points that you retrieve, the slower your process will run.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/sentinel-studio\/sentinel-studio-primers\/performance-considerations-in-data-windowing\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":43031,"parent":42145,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[704,468,731,726],"class_list":["post-42173","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-data-windows","tag-performance","tag-process-flow","tag-studio-sentinel","Version-4-6-1","Product-sen"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/42173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=42173"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/42173\/revisions"}],"predecessor-version":[{"id":46308,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/42173\/revisions\/46308"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/42145"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/43031"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=42173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=42173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=42173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}