"Do a search" always slower than using a reference regardless of database entries count

Why is it that “Do a search” is always slow, even when you have only 5 entries in that type?

As oppose to using a reference, which is always faster.

For example: “Current User’s Department” will always be faster than saying “Do a search” for departments, constraint by User = Current user, despite the fact that Department has only 5 records!

This topic was automatically closed after 70 days. New replies are no longer allowed.