[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