[sinucello]

Hi,

I just took a look at my mysql slow query log and found entries like this:

# Query_time: 0  Lock_time: 0  Rows_sent: 7  Rows_examined: 54101
SELECT t.champion, u.userid FROM tournaments AS t^M
                        LEFT JOIN user AS u ON (t.champion = u.username)^M
                        WHERE champion<>'';

u.username has an index. Maybe t.champion (text field) should have one too or the query could be optimized in another way? I`m no sql-expert, just wanted to mention it and hope it`s useful.

all the best,
Sacha