Extremely slow load time for 41k GDE rows

I got the go ahead from the client to use row owners to fix the loading times but the workouts currently use member ID’s and not email addresses. “Single Value” and “Lookup”columns can’t be row owners so how do I do this?