#24297bad performance - not using table index while deleting cached imagesize
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.