GROUP_CONCAT is very slow. So I used FastBit for the table instead! 43 seconds down to .16!

(Justin Swanhart) MySQL always tries to make toast of my good ideas. This is the only time is succeeds in making toast (see bug #2).

Read More - Register for Free Membership