Hallo zusammen,
inzwischen habe ich die Catalogerweiterung aktualisiert (sieh unten). Trotzdem gibt es SlowQuerys, zur Zeit von 12 Sekunden mit 9,4 Mio verarbeiteten Zeilen. Sie betreffen immer die gleiche cat_Tabelle und wiederholen sich mit geringen Abweichungen in einigen Werten.
Was kann ich tun???
Grüße
Fryd
SELECT DISTINCT(v_bundesland) FROM cat_veranstaltungen WHERE v_beginn>unix_timestamp() and v_freigabe=1 and v_komplett=1 AND id IN (SELECT DISTINCT(itemid) FROM tl_catalog_tag_rel WHERE fieldid=10 AND itemid IN (SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=10 AND valueid=38 AND itemid IN(SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=10 AND valueid=38)) AND valueid IN (38))
SELECT SUM(FIND_IN_SET(18,v_bundesland)) AS v_bundesland18, SUM(FIND_IN_SET(19,v_bundesland)) AS v_bundesland19, SUM(FIND_IN_SET(20,v_bundesland)) AS v_bundesland20, SUM(FIND_IN_SET(21,v_bundesland)) AS v_bundesland21, SUM(FIND_IN_SET(22,v_bundesland)) AS v_bundesland22, SUM(FIND_IN_SET(23,v_bundesland)) AS v_bundesland23, SUM(FIND_IN_SET(24,v_bundesland)) AS v_bundesland24, SUM(FIND_IN_SET(25,v_bundesland)) AS v_bundesland25, SUM(FIND_IN_SET(26,v_bundesland)) AS v_bundesland26, SUM(FIND_IN_SET(27,v_bundesland)) AS v_bundesland27, SUM(FIND_IN_SET(28,v_bundesland)) AS v_bundesland28, SUM(FIND_IN_SET(29,v_bundesland)) AS v_bundesland29, SUM(FIND_IN_SET(30,v_bundesland)) AS v_bundesland30, SUM(FIND_IN_SET(31,v_bundesland)) AS v_bundesland31, SUM(FIND_IN_SET(32,v_bundesland)) AS v_bundesland32, SUM(FIND_IN_SET(33,v_bundesland)) AS v_bundesland33, SUM(FIND_IN_SET(61,v_bundesland)) AS v_bundesland61, SUM(FIND_IN_SET(53,v_bundesland)) AS v_bundesland53 FROM cat_veranstaltungen WHERE v_beginn>unix_timestamp() and v_freigabe=1 and v_komplett=1 AND id IN (SELECT DISTINCT(itemid) FROM tl_catalog_tag_rel WHERE fieldid=10 AND itemid IN (SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=10 AND valueid=38 AND itemid IN(SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=10 AND valueid=38)) AND valueid IN (38))
Dies ist zur Zeit drauf:
contao: Version 2.9.5 mit Sicherheitspatch 2
catalog: Version 2.0.0 beta2 Built 74
backend_filterwiz: 0.1.2 Built 10
backand_tabletree: 0.1.2 Built 9 (verfügbar: 0.1.3 Built 16)
DC_DynamicTable: 0.1.0 Built 21
taxonimy: 0.1.8 Built 10
Die vom catalog abhängigen Erweiterungen sind:
catalogajaxratingfield: 2.0.0 beta1 Built 20
catalogitemhitsfield: 2.0.0 beta1 Built 20
catalogitemuseridfield: 2.0.0 beta2 Built 8
catalomultitextwizardfield: 2.0.0 beta1 Built 19
catalognotelist: 2.0.0 beta2 Built 9
Lesezeichen