Guy suggested that we surround the pivot data with clousers of functions to improve performance.
let's take sorting for example,
1) we can sort every time a user requests sort
2) we can save the sort so now we have duplicated data
3) we can create a clouser that saves some data, translation of the data to sorted data (like a dimension table), so now whenever this function is accessed it uses the clouser data to get the sorted values
this can also be used for every wrapper of function over the data
Guy suggested that we surround the pivot data with clousers of functions to improve performance. let's take sorting for example, 1) we can sort every time a user requests sort 2) we can save the sort so now we have duplicated data 3) we can create a clouser that saves some data, translation of the data to sorted data (like a dimension table), so now whenever this function is accessed it uses the clouser data to get the sorted values
this can also be used for every wrapper of function over the data