{"id":942,"date":"2023-08-04T13:42:05","date_gmt":"2023-08-04T13:42:05","guid":{"rendered":"https:\/\/bi-wooning.com\/performance-efficiency\/"},"modified":"2023-09-01T11:07:34","modified_gmt":"2023-09-01T11:07:34","slug":"performance-efficiency","status":"publish","type":"page","link":"https:\/\/bi-wooning.com\/en\/performance-efficiency\/","title":{"rendered":"Performance \/ Efficiency"},"content":{"rendered":"<p data-sourcepos=\"15:3-15:253\">The performance of reports depends on the underlying data model. There is a rule of thumb that every action in the report should not take longer than 10 seconds. If an action takes longer, there should be a valid explanation or justification.<\/p>\n<p data-sourcepos=\"17:3-17:292\">Simple things like data types can already have an impact on performance, especially as data volumes increase. For example, a column containing text data can occupy much more space than a column with numerical data. This can slow down the performance of queries and reports.<\/p>\n<p data-sourcepos=\"19:3-19:362\">Additionally, significant performance gains can be achieved through the use of aggregation. Aggregation is the process of combining data to create a higher-level summary. (Less detail) This can significantly enhance the performance of queries and reports, especially for users interested in the big picture and not the details (unless something is wrong).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The performance of reports depends on the underlying data model. There is a rule of thumb that every action in the report should not take longer than 10 seconds. If an action takes longer, there should be a valid explanation or justification. Simple things like data types can already have an impact on performance, especially [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":855,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-942","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/comments?post=942"}],"version-history":[{"count":2,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/942\/revisions"}],"predecessor-version":[{"id":944,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/942\/revisions\/944"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/media\/855"}],"wp:attachment":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/media?parent=942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}