Issue Bug Closed

#24297bad performance - not using table index while deleting cached imagesize

Vladimir Podkovanov 12/06/10, 10:03 updated 02/11/11, 11:04

Description

method t3lib_stdGraphic::getCachedImageDimensions deletes row like this:
// file has changed, delete the row
$TYPO3_DB->exec_DELETEquery (‘cache_imagesizes’, ‘md5hash=’.$TYPO3_DB->fullQuoteStr($row[‘md5hash’],‘cache_imagesizes’));
but table cache_imagesizes has index on md5filename not on md5hash so it leads to full table scan and slow performance

(issue imported from #M16685)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.