{"id":27481,"date":"2012-11-07T17:27:59","date_gmt":"2012-11-07T16:27:59","guid":{"rendered":"http:\/\/claudio.brignole"},"modified":"2024-01-16T12:42:16","modified_gmt":"2024-01-16T11:42:16","slug":"big-and-fast-spreadsheets-2","status":"publish","type":"post","link":"https:\/\/exmachina.ch\/en\/casestudies\/big-and-fast-spreadsheets-2\/","title":{"rendered":"Big and Fast Spreadsheets"},"content":{"rendered":"<p><strong>The Challenge<\/strong><br \/>\nGlobally exchanged\u00a0spreadsheets can quickly grow to 80 sheets and beyond. What is gained in flexibility makes for\u00a0frustratingly slow and unresponsive computers.<\/p>\n<p><strong>The Approach<\/strong><br \/>\nOur\u00a0BFS solution streams data instead of loading it\u00a0into memory, allowing for unprecedented speed and efficiency\u00a0while maintaining the original type (xlsx, xlsm,\u2026).<br \/>\n<strong><br \/>\nThe Benefits<\/strong><br \/>\nOpen a 50-sheet file in\u00a01 second instead of 1 minute and use only 30 MB instead of 2 GB, leaving plenty of\u00a0time and room for\u00a0actually utilising the data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Faced with a portfolio spawning 5 Continents, one of the largest insurance groups of the World needed a Global Database Solution.<\/p>\n","protected":false},"author":33,"featured_media":27518,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107],"tags":[],"class_list":["post-27481","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-casestudies"],"_links":{"self":[{"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/posts\/27481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/comments?post=27481"}],"version-history":[{"count":1,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/posts\/27481\/revisions"}],"predecessor-version":[{"id":27647,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/posts\/27481\/revisions\/27647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/media\/27518"}],"wp:attachment":[{"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/media?parent=27481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/categories?post=27481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exmachina.ch\/en\/wp-json\/wp\/v2\/tags?post=27481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}