Subset Recalculation and Filters

Liberty Create
1

Hello there

I’m trying to be as efficient as possible in use of time based subsets (where they can’t be avoided), and I’m wondering if the ordering of filters is a consideration in recalculation.

In recalculating a subset does the system always examine all filter conditions against each record?

So, in this example here:

image
image1371×356 15.4 KB

Will the system always compare Date Created against NOW() for each record regardless of the state of Expired?

Or when Expired is not equal to True will the system move on to the next record without comparing Date Created against NOW()?

Cheers :slight_smile:

2

@Ryan.Devine or @Darren.Hartley, any insight on this query? I would be interested to know also.

Thanks,

Jared

3

Hi,

This is a good question and line of thinking, but I don’t think the order will have any notable impact in this case. It’s not as clear cut as within code, where short-circuiting criteria in an IF statement for example would definitely be a benefit.

The subset criteria end up as clauses in an SQL query, and it is then up to the database engine to run that as optimally as possible. So those criteria may not be evaluated in the order written anyway, it will be up to the engine to determine the best approach, so there is no direct way to influence this by the order of your criteria.

1 Like
4

Thanks Bob, good to know :+1: