[SOLVED] JOIN Problem - Strange

[jaymc]

This query takes 150+ seconds, starts creating tmp tables on disk until I eventually kill it

 

SELECT f.member, f.timestamp, m.gender, m.lastact, c.propic

FROM fitlist f

INNER JOIN members m ON f.member = m.username

INNER JOIN cache c ON f.member = c.username

WHERE f.username = 'jamie'

ORDER BY f.timestamp DESC

LIMIT 0,10

 

But this almost identical query takes miliseconds, alls I have done is change the ON clause to be the other JOINED table table

 

SELECT f.member, f.timestamp, m.gender, m.lastact, c.propic

FROM fitlist f

INNER JOIN members m ON f.member = m.username

INNER JOIN cache c ON m.username = c.username

WHERE f.username = 'jamie'

ORDER BY f.timestamp DESC

LIMIT 0,10

[jaymc]

Please ignore

 

I had the wrong field type