That quote is a bit misleading really. The answer to the question is very complex, but Link= is nearly always faster unless you are returning a very small number of values from the link table (say less than 10) in which case NL(Filter) is faster. If you are in doubt about which one is faster on your report, it definitely pays to try both though.
Regards,
Hughes
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi
1. In term of best performance, which one is better to use, the nl(filter) or nl(link) ??
2. will the nested function impact on the perforamance ??
What is the best practice of using nl("filter"),nl("link") ??
Thanks. -
Jet Reports Historic Posts perhaps this post will explain it to youFor performance -
NL("Filter") should be used to filter one table based on data from another table that is of smaller or equivalent size
"Link=" should be used to filter one table based on data from a larger table
Please sign in to leave a comment.