Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 5 filter conditions need to perform on tfilterrow. Now is which gives better performance?
1. Giving all the conditions in one tfilterrow?
or
2. giving one tfilter row for one column condition like I need 5 filters for 5 conditions?
tfilter-->tfilter-->tfilter-- like this.
Good point about the order @TRF. Again this is an assumption, but since the tMap variables are strictly actioned from top to bottom (this I know), I would predict that the tFilterRow filters are processed in the same order. It would be interesting to test....but I reckon you would need a lot of data before you saw a repetitive difference between the order permutations.
Although I have not tested this, it is almost certainly using one tFilterRow component. The individual filters will all have to be run but by setting up a tFilterRow for each you are adding unnecessary initialisation latency.
I agree with @rhall.
May having the most restrictive filter first would be a little better, but in fact it depends how the code is generated.
You may check this if you display the source code in the Studio.
Good point about the order @TRF. Again this is an assumption, but since the tMap variables are strictly actioned from top to bottom (this I know), I would predict that the tFilterRow filters are processed in the same order. It would be interesting to test....but I reckon you would need a lot of data before you saw a repetitive difference between the order permutations.