I haven't made much use of Memory Tags, but I am curious about when they may be better or worse than Custom Session props. I recently have had to use them, or probably didn't have to, but chose to, and it has me wondering about best practices and such.
Is there a gain from performance to using one vs. the other? Other than if the situation can only be accomplished by one verse the other, if they could both be used, what's the deciding factor?
For example, I have a display where data is shown on dynamic tables. I kind of hard set up each table to be visible based on a drop-down selection, then if drop down is X, display Y table. Originally, they were bound directly to named queries, but I don't think 10 tables stacked on top of each other on a singular display running 10 queries seemed smart, especially when only one is being looked at in any given moment. So, I made some scripting to just query the information for the displayed table. The other tables still exist, hidden, on the display. This too doesn't seem ideal.
Now I am thinking, why not go down to a singular table, and add the props that get altered to send to the table just ahead of the query populating the data.
Of course, that means I need to save the table props in question, i.e. the column data and such. Could I make a single object in a memory tag of document style, in which I have nested lists perhaps, each list for a specific table containing the column list and other relevant things like x,y,height,width in a second list.
Is this ALL just bad practice and I am skinning the cat wrong entirely? This specific example I just stated could easily go in Custom Session Props, I am sure. Or is storing it once in a memory tag smarter than 10 instances of the session props having to populate all of that information?
It may be clear from these questions and verbiage I am using, but I have no clue what I am doing.