Langsame DB Abfrage

[Naps]

Hi,

kann mir Jemand vielleicht Verbesserungsvorschläge für diese Abgfrage machen?

SELECT s.ID, headline, uId, teaser, hide_image_archiv, image, image_caption, date_format(cDate, '%d.%m.%Y | %H:%i Uhr') as date, channelid, channel_article.name FROM  
    (SELECT article.ID, uId, headline, teaser, cDate, image, image_caption, channelid, hide_image_archiv  
    FROM article  
    inner join article_cCountry on article.ID = ID1 and ID2 = 1  
    where sDate < now()  
    and (eDate > now() or eDate = 0)  
    and released = 'TRUE'  
    and (uId in (select ID from user where released = 1) or uId = 0)  
ORDER BY cDate DESC) AS s, channel_article where channelid = channel_article.ID AND channelid = 8 order by cDate desc LIMIT 3

Derzeit benötigt die Abfrage 0,3 bis 0,5 Sek.

Danke, MfG
Naps