One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.

Great point. I had not considered the angle you raised in the second paragraph — it reframes the whole thing for me.

Thanks for writing this up. Bookmarking it — the kind of thing I will want to reference again in a month.

For what it is worth, the same approach works with the PMPro adapter — the membership side is identical from here.

For what it is worth, the same approach works with the PMPro adapter — the membership side is identical from here.