Project

General

Profile

Actions
Copy link

Bug #24297

closed

bad performance - not using table index while deleting cached imagesize

Added by Vladimir Podkovanov almost 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Christian Kuhn
Category:
-
Target version:
-
Start date:
2010-12-06
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.4
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

Files

Download all files
bug_16685.patch (1.35 KB) bug_16685.patch Administrator Admin, 2011-01-16 06:20
16685_02.diff (2.22 KB) 16685_02.diff Administrator Admin, 2011-01-18 21:30
Actions
Copy link
 #1

Updated by Christian Kuhn almost 14 years ago

trunk rev. 10122

Actions
Copy link

Also available in: Atom PDF