Page 1 of 1

Does Filter order matter in processing?

PostPosted: Thu Feb 13, 2014 10:51 am
by whiskyjohn
Sorry if this question has been asked before. I could not find an answer.

I've been testing some combination of filters with NoteTracker. Some of them are simple, like
filter only hands with the player on the button. Some are more complex, like filter out draws
with certain hand ranges.

As a programmer, I figured that I would put what I considered the simplest filters first and the
more elaborate filters last, thereby excluding hands which don't match the set of criteria faster.

On a large data set, should I expect to see any performance increase from this prioritization?
If so, are there some general guidelines that I should follow when ordering filters?

Perhaps internally, PT does or could optimize these filters accordingly?

Thanks for any advice,
John

Re: Does Filter order matter in processing?

PostPosted: Thu Feb 13, 2014 12:28 pm
by kraada
PostgreSQL is going to do its own prioritization so I don't think the order you place them in matters; PostgreSQL's query plan is what will matter.

highfalutin