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.

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

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

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

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