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

We ran into the same situation last quarter. What worked for us was starting small and only adding complexity when a real need showed up.

Could you say more about how you measured the result? I want to try this but I am not sure what success would look like.

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

Following this thread closely. We are about to face the exact same decision and the replies here are gold.

We ran into the same situation last quarter. What worked for us was starting small and only adding complexity when a real need showed up.