GROUP_CONCAT slow in MySQL -
i have following query in mysql:
select query.*, group_concat(coalesce(query.gene,'none'), '(', query.loc, '|', coalesce(query.typ,'unknown'), ')') outt ( select genes.loc, genes.typ, genes.abans, genes.despres, genes.gene, mutations.id,mutations.chr,mutations.pos,mutations.ref, mutations.ale,mutations.g001,mutations.g002,mutations.g003, .... (snipped hundreds of denormalized fields).... genes inner join mutations on genes.id=mutations.id (mutations.g001>=0.40 , mutations.g002>=0.40 , mutations.g003>=0.40 , mutations.g004>=0.40 , mutations.g005>=0.40 , mutations.g006>=0.40 , mutations.g007>=0.40 , mutations.g008>=0.40 , mutations.g011>=0.40 , mutations.g012>=0.40 , mutations.g013>=0.40 , mutations.g014>=0.40 , mutations.g015>=0.40 , ....(you idea)... , mutations.g105>=0.40 ) limit 0, 100 ) query group query.id
i group_concat
in query , works quite well. problem want 100 rows, while less 100 rows due group by
. when trying apply group_concat
directly inner query, extremely slow. have suggestions?
Comments
Post a Comment