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

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Wed Feb 28 15:32:02 CET 2007


Peter Russ schrieb:
> 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.

Quite obviuos ;-)

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

You say "could" but give a number. Does this mean you have tried it and 
your site experiences this perfomance boost?

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

IMHO we should move on to 4.0 or later for TYPO3 4.2 anyway. But what about 
DBAL? Not all DBs come with a full text indexed and if the definition and 
query syntax will be different. It'd be fine if this can be handled gracefully.

Or you simply create an XCLASS extension for this. But I don't know how to 
add the changed index in the ext_tables.php.

Masi


More information about the TYPO3-english mailing list