[TYPO3-dam-devel] RFC #0010318 dam > info crashes on larger installs

[Thorsten Kahler]

Hi DAM team,

this is an SVN patch request.

Type: Bugfix

Bugtracker reference: http://bugs.typo3.org/view.php?id=10318

Branches: trunk, 1.1

Problem:
BE module Media > Info crashes on larger installations due to a SQL join
using the LIKE operator. This leads to endless query times

Solution:
The attached patch "pre-filters" the LIKE conditions by duplicating the
condition and using the "=" operator instead of LIKE. This duplicated
condition can use the existing index in table sys_refindex so the
cartesian product is reduced to a minimal fraction.

I left the LIKE condition because there might be installations in the
wild that contain different charsets and collations. In these
(admittedly rare) cases the "=" operator might provide false result
because it uses the collation. (e.g. "grøn.gif" would match as well as
"groen.gif").

See bugtracker for a more detailed explanation.

Cheers
Thorsten

-- 

Thorsten Kahler
thorsten.kahler at dkd.de