While creating a VBO view to check if a user reference was empty the process timed out when adding a user reference field filter.

After doing some digging, I discovered that the reference field in filter was the culprit. It tries to render option form fields for all possible matches! In this specific case this means ~15k users. Attached Is a screenshot of the profile I did.

I don't know what would be a proper solution to this problem, but I speculate this also applies to the nodereference field.

I worked around this issue by disabling the in filter all together.

CommentFileSizeAuthor
snapshot2.png257.93 KBjoostpluijmers
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Alex Andrascu’s picture

Alex Andrascu CreditAttribution: Alex Andrascu commented

Thanks for spotting this one!

Alex Andrascu’s picture

Alex Andrascu CreditAttribution: Alex Andrascu commented

Can you please post the filter settings too ? Thanks.

joostpluijmers’s picture

joostpluijmers CreditAttribution: joostpluijmers commented

I never got to the phase where I could specify the filter setting. When adding the filter it already timed out on rendering the settings form!

Alex Andrascu’s picture

Alex Andrascu CreditAttribution: Alex Andrascu commented
Version: 7.x-2.1 » 7.x-2.x-dev
Assigned: Unassigned » Alex Andrascu

I see. Thanks for your fast reply.

joostpluijmers’s picture

joostpluijmers CreditAttribution: joostpluijmers commented

No problem. I would recon the fields auto complete behavior would be an elegant solution for people who would like to use the IN() filter. But thats just my opinion.

If you post back with a fix ill try and test it!

noslokire’s picture

noslokire CreditAttribution: noslokire commented

Same issue for us, attempting to add a filter results in a timeout. We have close to 50k users