What has worked for you in general discussion?

I respectfully disagree on one detail. In my setup the opposite held true, though I suspect it comes down to community size.

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

This is the answer I wish I had found six months ago. Would have saved me a weekend of trial and error.

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

Tried this on a staging copy first and it behaved exactly as described. Confident enough to roll it to production now.

I respectfully disagree on one detail. In my setup the opposite held true, though I suspect it comes down to community size.