Hi, i have a code like this:SELECT tp.id_invoice, GROUP_CONCAT(mbrg.name) AS goodsFROM t_payment AS tp INNER JOIN t_invoices AS tnj ON tp.id_invoice = tnj.id INNER JOIN d_invoices AS dnj ON dnj.id_invoice=tnj.id INNER JOIN m_goods AS mbrg ON mbrg.id=dnj.id_goods INNER JOIN m_customer AS mc ON tnj.id_customer = mc.id where tp.`status`=1 GROUP BY tp.id_invoices
My query work properly when i use small data, but when my data is growing 1000++, my query work very slow. Executing time is above 5 minutes only for execute this query.Thx for help me.NB: Sorry I'm from Indonesia, my English not well.
Optimized Query With Medium - Huge Data
Posted - 2012-05-10 : 13:16:14
