[Vince]

Hmm, your datamodel is questionable at best. 'Leader' should be an attribute of Faction, not an attribute of Player. As a quick patch you can put an index on that 'leader' column to speed up table lookups, but in the long term you should probably restructure the datamodel.

Also run an explain query (within phpMyAdmin or other client) and put the output here:

PHP код:

EXPLAIN SELECT user, ID, LastLogin FROM `players` WHERE `Leader` = '1' 


If it says something like "table scan" or indicates the possible keys as NULL then that's bad.