[sneaK]

Originally Posted by AeroAcrobat I've added an index on the auth field. Query duration went from 90 seconds to 0.01 seconds. Spoiler No auth index +------+-------------+------------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+------------------+------+---------------+------+---------+------+---------+-------------+ | 1 | PRIMARY | player_analytics | ALL | NULL | NULL | NULL | NULL | 5986079 | Using where | | 2 | SUBQUERY | player_analytics | ALL | NULL | NULL | NULL | NULL | 5986079 | Using where | +------+-------------+------------------+------+---------------+------+---------+------+---------+-------------+ With auth index +------+-------------+------------------+------+---------------+------+---------+-------+------+------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+------------------+------+---------------+------+---------+-------+------+------------------------------------+ | 1 | PRIMARY | player_analytics | ref | auth | auth | 99 | const | 64 | Using index condition | | 2 | SUBQUERY | player_analytics | ref | auth | auth | 99 | const | 64 | Using index condition; Using where | +------+-------------+------------------+------+---------------+------+---------+-------+------+------------------------------------+

Sorry, could you explain how to accomplish this, is this a plugin change and/or a database change?