[TYPO3] [TYPO3-dev] Indexed Search Performance Improvement

[Peter Russ]

It takes several 10s of seconds to get search result displayed.

The problem is the "fulltext" search on a regular index either on 
index_fulltext.fulltext or on index_words.baseword performed by a
"where index_words.baseword like '%nonsense%'" query.

We could speed up the time (10s of sec down to millisec) by doing the 
following:

1) adding fulltext index to index_fulltext.fulltext and index_words.baseword

2) changed query in class.tx_indexedsearch.php to use fulltext 
capabilites of MySql.

Limitation: requires newer versions of MySql (4.0 or later)

Diff for TYPO3 4.0.5 can be found here:
http://bugs.typo3.org/view.php?id=5089

Comments welcome.

Regs. Peter.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ