[TYPO3-core] RFC #13273: Bug: Caching framework sub-select is slow because mysql does not use indexes on outer query

[Christian Kuhn]

FYI:

Taking Xavier's remarks into account, attached v3 is now committed to:
- trunk rev. 7204
- TYPO3_4-3 rev. 7206

Committed testcase fix to:
- trunk rev. 7205
- TYPO3_4-3 rev. 7207

Thanks
Christian

Christian Kuhn wrote:
> Type: bugfix
> 
> BT reference: http://bugs.typo3.org/view.php?id=13273
> 
> Branches: trunk, TYPO3_4-3
> 
> Problem:
> mysql is unable to use indexes for outer query if where clause is a sub
> select [1]. This makes tag-deletion in the caching framework with db
> backend very slow on bigger tables because mysql happily decides to
> perform a full table scan.
> 
> Solution:
> Separate queries and do more logic with php.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 13273_03.diff
Type: text/x-patch
Size: 3983 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100328/b8adc115/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 13273_03_testcase_fix.diff
Type: text/x-patch
Size: 957 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100328/b8adc115/attachment-0003.bin>