>Which is faster: set relation to, or set filter ?
These two commands are not comparable since they serve to completely differnt purposes. Set relation is used to join two tables, set filter is used to filter the relevant records.
Anyway, I suggest that you try to avoid these commands as much as possible, you can usually write ONE line of code using SQL Select or SQL Update to get the same result as a whole bunch of lines using "old" code.