Frontpage repeated query! - Joomla! Forum - community, help and support


hi, trying optimize joomla queries (even though im beginner) , noticed on front page when turned debug mode on, notice 2 exact queries 1 after other(except 1 small difference mentioned below)

code: select all

 select a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.access, case when char_length(a.alias) concat_ws(':', a.id, a.alias) else a.id end slug, case when char_length(cc.alias) concat_ws(":", cc.id, cc.alias) else cc.id end catslug, char_length( a.`fulltext` ) readmore, u.name author, u.usertype, g.name groups, cc.title category, s.title section, s.ordering s_ordering, cc.ordering cc_ordering, a.ordering a_ordering, f.ordering f_ordering
        jos2_content a
        inner join jos2_content_frontpage f
        on f.content_id = a.id
        left join jos2_categories cc
        on cc.id = a.catid
        left join jos2_sections s
        on s.id = a.sectionid
        left join jos2_users u
        on u.id = a.created_by
        left join jos2_groups g
        on a.access = g.id
        1
        , a.access <= 2
        , a.state >= 0
        order by  f.ordering
        limit 0, 6


and

code: select all

  select a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.access, case when char_length(a.alias) concat_ws(':', a.id, a.alias) else a.id end slug, case when char_length(cc.alias) concat_ws(":", cc.id, cc.alias) else cc.id end catslug, char_length( a.`fulltext` ) readmore, u.name author, u.usertype, g.name groups, cc.title category, s.title section, s.ordering s_ordering, cc.ordering cc_ordering, a.ordering a_ordering, f.ordering f_ordering
        jos2_content a
        inner join jos2_content_frontpage f
        on f.content_id = a.id
        left join jos2_categories cc
        on cc.id = a.catid
        left join jos2_sections s
        on s.id = a.sectionid
        left join jos2_users u
        on u.id = a.created_by
        left join jos2_groups g
        on a.access = g.id
        1
        , a.access <= 2
        , a.state >= 0
        order by  f.ordering


and difference last limit line, 1 has it:

code: select all

limit 0, 6
hmm wondering why is? , if neccessary? can 1 deleted(and where)

also publish 6 articles on frontpage @ time! please help!!






Comments

Popular posts from this blog

CS5 Adobe Media Encoder: Encode failed because the source duration is nil.

cf_sql_integer vs cf_sql_bigint vs cf_sql_int??

localhost/joomla15/administrator doesnt work - Joomla! Forum - community, help and support