To moj pierwszy post i mam nadzieje, ze bedzie nam sie dobrze wspolpracowac
Na dzis mam problem, mam zapytanie ktore zwraca 3,9k recordow. Na chwile obecna mam 3,19s i nie mam pomyslu jak zejsc nizej.
Wiem, ze sama suma zzera 1,5s- sprawdzalem.
Bede wdzieczny za rady.
Zapytanie:
SELECT pure_sales.id pid,
pure_sales.week tydzien,
pure_sales.data data,
pure_sales.invoice_id faktura,
pure_sales.company_name dystrybutor,
pure_sales.quantity ilosc,
pure_sales.value wartosc,
pure_sales.part_number produkt,
tfirm.id fid,
tfirm.name fname,
tperson.name pname,
tperson.family pfamily,
(SELECT SUM(value * quantity) FROM pure_sales WHERE pure_sales.id=pid) suma,
(SELECT tcity.name FROM tcity INNER JOIN tfirm ON tcity.id=tfirm.city WHERE tfirm.id=fid) cname,
(SELECT tvojevod.name FROM tvojevod INNER JOIN tfirm ON tvojevod.id=tfirm.vojevodship WHERE tfirm.id=fid) vojev,
(SELECT name FROM tcust_cat_value INNER JOIN tcust_cat_firm ON tcust_cat_value.id=tcust_cat_firm.cust_cat_value_id WHERE tcust_cat_firm.firm_id=fid) kanal,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 2 AND tprod.sku=produkt) grupa,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 13 AND tprod.sku=produkt) OS,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 5 AND tprod.sku=produkt) CPU,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 3 AND tprod.sku=produkt) ekran,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 8 AND tprod.sku=produkt) disc,
(SELECT tcv.name FROM tprod_cat_value as tcv INNER JOIN tprod_cat_relation as tcr on tcr.prod_cat_value_id=tcv.id
INNER JOIN tprod ON tprod.id=tcr.prod_id WHERE tcv.prod_cat_id = 7 AND tprod.sku=produkt) ram
FROM pure_sales
INNER JOIN tfirm ON tfirm.nip=pure_sales.nip
LEFT JOIN tnip_salesman ON tnip_salesman.firm_id=tfirm.id
LEFT JOIN tperson ON tperson.user_id=tnip_salesman.user_id