Need help :-(

[Shane Zammit]

Hi,

I have the below query which is talking around 180sec to run... Can anyone suggest a change to make it run quicker?

# Time: 090518 13:31:14
# User@Host: ez @ localhost []
# Query_time: 181 Lock_time: 0 Rows_sent: 5 Rows_examined: 2540
SELECT DISTINCT `Tweets`.* FROM `TweetFollowers`, `Tweets` WHERE
((`Tweets`.`Poster` = `TweetFollowers`.`MemberID` AND
`TweetFollowers`.`Follower` = '2554') OR `Tweets`.`Poster` =
'2554') AND `Post` != '' ORDER BY `Posted` DESC LIMIT 5;

Thanks is advance....