About using "intersect with" in repeating groups

Performance will be terrible. Bubble will download the entire results of each individual search to the page, then do the intersects there.

Advanced filter will load what it needs to the page in order to fill the RG container. With large datasets, performance is bad, but not as bad as intersect with.

Both of the above are made worse by the fact that Bubble will download every field from a record (unless the field is blocked by privacy rules).

I did some experiments with this stuff. See the below post.