[TYPO3-core] RFC #16685: Bug: bad performance - not using table index while deleting cached imagesize [performance]

Vladimir Podkovanov admin at sitesfactory.ru
Sun Jan 16 06:40:50 CET 2011


This is an SVN patch request.

Type: Bugfix

Bugtracker references: http://bugs.typo3.org/view.php?id=16685

Branches: TYPO3_4-4, trunk

Problem:
When deleting row from cache_imagesizes table index not used that 
causing full table scan and it is a problem on big table.

Solution:
Change "where" clause to use primary index.

-- 
-rgds-
Vladimir
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: bug_16685.patch
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20110116/fb48b0c8/attachment.txt>


More information about the TYPO3-team-core mailing list