Druckversion des Themas

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.