[Typo3-dev] indexed_search - Performance Issue Questions

[Michael Stucki]

Maybe someone didn't see this topic? What we need is an SQL expert who knows
how indexed_search queries can be tuned.

Have a look at doc/TODO.txt in indexed_search.

- michael

Kasper Skårhøj wrote:

> I think the indexing part of Indexed Search is fine. It could be faster in
> terms of splitting words, but this should only take some hardcore
> programmer to improve (notice the recent speed-reduction is due to its
> support for UTF-8 so a trivial preg_split-thingy will not work...)
> 
> The searching part is more tricky. First of all it will traverse the page
> tree and use page IDs for the look ups. With thousands of pages this
> becomes slow. Can be disabled I think. On typo3.org we had a VERY slow
> search. Why? Well, because we allowed to search for "part of word" which
> generated too big result tables. Simply setting it to "distinct" word
> speeded it up some 100 times. I don't know how to implement a fast
> "part-of-word" search but surely some wise guy out there can do that!
> What we need: Someone to tune the SQL part of searching for indexed
> search!
> 
> Generally, what I believe is done well enough is the indexing architecture
> of word-/rel-/phash table, all we need is to improve the facilities that
> searches them!
> 
> - kasper
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/