Category: Performance

Performance - Why is LookUp better than First/Filter?

Two popular ways to retrieve a single record are to call LookUp, or First(Filter. From a performance perspective, it's better practice to call the LookUp function to return a single record. This to post describes the reason why it's better to call LookUp, compared to First/Filter.