group_concat query performance

Question

A MySQL query is running significantly slower since adding a group_concat clause. Currently, this query looks as follows:

select ... group_concat(distinct category.name) .... from page where 
left outer join page_category on page.id = page_category.page_id  
left outer join category on page_category.category_id = category.id
....
group by page.id

As mentioned in the query, among others, my application has 3 tables: page, category, and page_category. A page can be associated with none or multiple categories. Currently page, page_category, and category have 9,460, 20,241 and 10 entries, respectively.

Can anyone help me to improve this query to improve its performance?

Sergio del Amo · Accepted Answer · 2008-09-02 16:42:27Z

1

I was missing an index in the page_category.page_id field. That solve the problem.

answered Sep 2, 2008 at 16:42

Sergio del Amo

78.3k68 gold badges154 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

group_concat query performance

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related