da einem meiner auftritte quasi über nacht extrem lange ladezeiten entwickelt hat habe ich mich diesbezüglich mit meinem provider in verbindung gesetzt.
neben der tatsache, dass es aktuell tatsächlich probleme mit dem server gibt habe ich noch diese information erhalten:
ZITAT
Alledings findet sich zu Ihrem Paket immer wieder folgendes Slow MySQL Query:
SELECT CONTENT.idcontent , CONTENT.idsidelang , CONTENT.container , CONTENT.number , CONTENT.idtype , CONTENT.typenumber , CONTENT.value , CONTENT.online , CONTENT.`version` , CONTENT.author , CONTENT.created , CONTENT.lastmodified , UPLOAD.idupl , UPLOAD.idclient , UPLOAD.titel , UPLOAD.filename , UPLOAD.iddirectory , UPLOAD.idfiletype , UPLOAD.pictwidth , UPLOAD.pictheight , UPLOAD.pictcolors , UPLOAD.pictthumbwidth , UPLOAD.pictthumbheight , UPLOAD.filesize , UPLOAD.used , UPLOAD.`status` , UPLOAD.description , UPLOAD.author AS upl_author , UPLOAD.lastmodified AS upl_lastmodified , UPLOAD.created AS upl_created , FILETYPE.filetype , FILEDIR.dirname FROM cms_content AS CONTENT LEFT JOIN cms_upl AS UPLOAD ON ( (( CONTENT.value = CONCAT('cms://idfile=', UPLOAD.idupl) ) AND ( UPLOAD.idclient = '1' ) ) OR (( CONTENT.value = CONCAT('cms://idfilethumb=', UPLOAD.idupl) ) AND ( UPLOAD.idclient = '1' ) ) ) LEFT JOIN cms_filetype AS FILETYPE ON ( UPLOAD.idfiletype = FILETYPE.idfiletype ) LEFT JOIN cms_directory AS FILEDIR ON ( UPLOAD.iddirectory = FILEDIR.iddirectory ) WHERE ( idsidelang = '388' ) AND ( container IN ( '2' ) ) ORDER BY CONTENT.container , CONTENT.typenumber , CONTENT.number;
Das barucht recht lange und verwendet fuer die Tabelle UPLOAD (tatsächlicher Tabellenname 'cms_upl') keine Indizes. Das Setzen von Indizes könnte hier helfen.
SELECT CONTENT.idcontent , CONTENT.idsidelang , CONTENT.container , CONTENT.number , CONTENT.idtype , CONTENT.typenumber , CONTENT.value , CONTENT.online , CONTENT.`version` , CONTENT.author , CONTENT.created , CONTENT.lastmodified , UPLOAD.idupl , UPLOAD.idclient , UPLOAD.titel , UPLOAD.filename , UPLOAD.iddirectory , UPLOAD.idfiletype , UPLOAD.pictwidth , UPLOAD.pictheight , UPLOAD.pictcolors , UPLOAD.pictthumbwidth , UPLOAD.pictthumbheight , UPLOAD.filesize , UPLOAD.used , UPLOAD.`status` , UPLOAD.description , UPLOAD.author AS upl_author , UPLOAD.lastmodified AS upl_lastmodified , UPLOAD.created AS upl_created , FILETYPE.filetype , FILEDIR.dirname FROM cms_content AS CONTENT LEFT JOIN cms_upl AS UPLOAD ON ( (( CONTENT.value = CONCAT('cms://idfile=', UPLOAD.idupl) ) AND ( UPLOAD.idclient = '1' ) ) OR (( CONTENT.value = CONCAT('cms://idfilethumb=', UPLOAD.idupl) ) AND ( UPLOAD.idclient = '1' ) ) ) LEFT JOIN cms_filetype AS FILETYPE ON ( UPLOAD.idfiletype = FILETYPE.idfiletype ) LEFT JOIN cms_directory AS FILEDIR ON ( UPLOAD.iddirectory = FILEDIR.iddirectory ) WHERE ( idsidelang = '388' ) AND ( container IN ( '2' ) ) ORDER BY CONTENT.container , CONTENT.typenumber , CONTENT.number;
Das barucht recht lange und verwendet fuer die Tabelle UPLOAD (tatsächlicher Tabellenname 'cms_upl') keine Indizes. Das Setzen von Indizes könnte hier helfen.
was haltet ihr (die ihr den tieferen sinn dahinter versteht) davon? sollte man daran etwas machen??
gruss, oberbilker