Move member plan data from usermeta into dedicated plan and subscription tables with full subscription history, linked to payments and activity, rolled out in phases (write to both now, read switch next, usermeta removed later).
This will improve the speed and performance.