can you try these two bits of the last clause individually to see if one of those is the culprit ?
(bes computers, unique values whose (multiplicity of it > 1) of names of bes computers )
UPDATE
Just tried the individual queries - they run fine with 250,000 endpoints.
Seeing it slow down when the two queries are used to form the tuple, even when there’s only one entry on the right of the tuple
Refactored to this and with 250,000 endpoints getting sub second response.
Seems like constructing the tuple using the two bes computer queries in the same tuple was the problem.
I’ve not duplicate names - but if I do put in some computer names for the last clause it works too.
(name of it, id of it)
of
items 0 of it whose (name of item 0 of it = item 1 of it)
of (bes computers, it)
of (unique values whose (multiplicity of it > 1) of names of bes computers)