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

[JohnY]

The difference in speed is phenomenal!  This has to be implemented into the 
core for the supported DB's.

THANKS SO MUCH FOR POSTING THIS!





"Peter Russ" <peter.russ at 4many.net> wrote in me!ssage 
news:mailman.1.1172671573.14329.typo3-dev at lists.netfielders.de...
> 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