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

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

Solid breakdown. The only thing I would add is to back up before making the change — better safe than sorry.

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

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.