[TYPO3] search for large sites

[Martin Kutschker]

Dave Chewter schrieb:
> Hi All
> 
> Just wondering how many people here find problems with indexed search on 
> large sites. It's a subject that comes up again and again on the lists but 
> never seems to get a huge amount of response, which is probably to be 
> expected as many people don't reach the limits of what indexed search can 
> do.
> 
> Our site has ~27,000 pages of content which correlates to a index_rel table 
> with over 2 million rows of data. The search slows to a crawl (somewhere 
> between 10 and 30 seconds to get a search result) and pushes server load up 
> considerably when multiple searches are being performed.

Do you allow searches for parts of word? Does it make a difference if 
you do "word contains X" or "word is X" searches?

Did you try to remove all the "garbage" entries in the search index 
tables? I mean they contain strings with the length one and two which is 
practically useless and only wastes space (and therefor time).

But to answer your question, I think that all of those who faced such an 
indexed search problem did either use another search or put much effort 
into enhancing the search. Both groups don't seem to be willing to share 
the outcome.

Masi