The case for smaller, focused communities

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

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

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.

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