[TYPO3] Indexed search query optimization

[Jan Bednarik]

Hi folks,

I've got problem with indexed search. This query:

SELECT IR.phash
                         FROM index_words IW,
                                                 index_rel IR,
                                                 index_section ISEC
                         WHERE
                                 IW.baseword LIKE '%lesovůz%'
                                                 AND IW.wid=IR.wid
                                                 AND ISEC.phash = IR.phash
                                                 AND ISEC.rl0 IN (16)
                                                  AND is_stopword=0
                         GROUP BY IR.phash;

takes 5 minutes to execute, checking 11 milion of rows.

The Typo3 is old 3.8.0 with old indexed search extension. However, this 
query is the same in the newest version.

Any ideas? Indexes are OK.

-- 
Jan Bednarik
www.bednarik.org - web about Typo3 in czech