Mike, I have a similar issue, which for me is a separate issue where I’m trying to filter a list of entries based on a list of subject tags. Each entry has multiple subject tags, which are set up as an option set. For now I’m using an advanced filter and “intersect with”, which I learned of here: Searching using multi dropdown - possible/alternative? Incompatible type.
On my initial testing it’s working fast enough to live with it – but my search is pretty simple in that it’s just filtering a list of entries based on subject tags. I have the results set up as a scrolling repeating group, so Bubble only has to find enough to fill the first few entries. I’ll likely also have to put a note for the user that if they are searching on subject tags, to be patient. I’m on a professional plan - not sure if that makes a difference.
I had asked Bubble support whether there was a way to do this “searching a list based on list” search client side, which should be faster, and they said no.