I have a date based application, and events are added haphazardly, so it is very important for me to always sort by Date. Does it make sense for performance to create a sorted table that I can then reference everywhere.
For instance, if I have DB_Events (table), Can I just also create a Var_SortedEvents and use that everywhere and essentially never reference DB_Events. If so, is there a difference between setting Var_SortedEvents in the two following ways. Are there any limitations to either? Does anyone even do this?
(1) In the canvas just type “=DB_Events.Sort(true, DB_Events.Date)”, and then give that canvas formula the name Var_SortedEvents.
(2) Create a view by writing “/table” and select DB_Events, and then setting the sort setting in Table Options. Then naming the view Var_SortedEvents.