Ką rodo:

EXPLAIN EXTENDED  SELECT ....

?

-Mindaugas J.

"tobias" <oracullusTRINAM@yahoo.com> wrote in message news:gmc593$9aa$1@trimpas.omnitel.net...
> kaip optimizuoti mysql query - jei jis vykdomas 40 sekundziu!
> jokiu fokusu nedarau
> paselektinu straipnio id, headline,
> is komentaru lenteles suskaiciuoju komentaru skaiciu
> 
> aciu uz komentarus
> 
> 
>     SELECT articles.id,
>     articles.title,
>     articles.date,
>     DATE_FORMAT(date,'%m/%d, %Y') as ArticleDate,
>     articles.selected_foto,
>     articles.foto_1,
>     articles.foto_source,
>     REPLACE(articles.source, ',', ' ') as source,
>     LEFT(articles.article,350) as article_intro,
>     COUNT(comments.id) as artComments
>     FROM articles
>     LEFT JOIN comments ON articles.id = comments.object_id
>     WHERE articles.active  = '1'
>     AND articles.category  = '21'
>     GROUP BY articles.id
>     ORDER BY articles.id
>     DESC
>     LIMIT 5 
> 
>