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

[Dan Osipov]

+1 by reading, although the two statements are strange.

On 1/7/11 7:09 PM, Thorsten Kahler wrote:
> 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
>

-- 
Dan Osipov
http://danosipov.com/blog