[TYPO3] [TYPO3-dev] Indexed Search Performance Improvement
sadffsdf at swefsdf.com
Mon Apr 16 20:31:04 CEST 2007
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
> 1) adding fulltext index to index_fulltext.fulltext and
> 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:
> Comments welcome.
> Regs. Peter.
> Fiat lux!
> Docendo discimus.
> 4Many® Services
> openBC: http://www.openbc.com/go/invuid/Peter_Russ
More information about the TYPO3-english