[PlayStation]

you need to understand, that the lagging comes from querying process during gameplay, which affects fps and if every players queries 500k rows no wonder it lags

if you would separate players for example by nickname you will have 10-30k in each table maybe, also i don't think all players are active, you could speed up your SELECT'ion if you just check which players are active