[TYPO3] Indexed search query optimization

Dmitry Dulepov [typo3] dmitry at typo3.org
Thu Sep 18 22:35:38 CEST 2008


Hi!

Jan Bednarik wrote:
>                         WHERE
>                                 IW.baseword LIKE '%lesovůz%'

<skip>

> Any ideas? Indexes are OK.

When you have "like '%whatever%'", you can forget about indexes. They will not be used because it does not make sense with '%...%'. It is always the whole table scan. Change search mode to exact or beginning. It will get rid of at least the first %.

-- 
Dmitry Dulepov
TYPO3 Core team
My TYPO3 book: http://www.packtpub.com/typo3-extension-development/book
In the blog: http://typo3bloke.net/post-details/tag_your_typo3_extension_releases_in_svn/


More information about the TYPO3-english mailing list