Merge query slows down when I expand user fields using SharePoint lists

[bradcuris]

Greetings,

I have a merge query that does a join to a list with 5 user fields. When I expand those user fields to find the first name and last name the query slows way down. Is this because the user fields are basically lookups? Is this normal?

I tried to optimize the query and reduce the number of fields that I return to the bare minimum. It appears when I hit the Step that extracts the names, the query slows down.

[otravers]

Yes this is normal, merges are fairly expensive and can get (very) slow.

[bradcuris]

Thanks, but when I take the people fields out of the query, it is under a minute to return.