[TYPO3-dev] Sphinx for indexed_search

[Ernesto Baschny [cron IT]]

Ingo Renner wrote: on 06.05.2008 15:36:
> Martin Kutschker wrote:
> 
> Hi Masi (and everybody else interested in cool numbers),
> 
>> I think we should rather implement nested lists for "pages" (as a TCA 
>> feature!) than add this crutch. Other than that: why didn't you cache 
>> in-memory?
> 
> no, because it would break too much stuff, you should know that yourself 
> already.
> 
>> What is worth caching is the search result. Why redo the search every 
>> time the user invokes paging in the browser?
> 
> if you think caching the search result is worth it, go ahead...
> 
> However, as I said: by caching the result of getTreeList all other 
> extensions using pi_getPidList from pibase will benefit, too!
> 
> Here're some rough numbers from my test system:
> 
> indexed_search as in 4.2, pagetree with about 3000 pages, about 1000 
> pages in index, search for a single word with about 250 results:
> about 17 seconds
> 
> indexed_search with mysql fulltext index:
> about 8 seconds
> 
> indexed_search with mysql fulltext index and getTreeList cached:
> about 4 seconds

Heh ok, the performance gain is there, but the real result is not very 
impressive, I must admit. I would expect a search in such a "tiny" 
document collection to appear in a fraction of a milisecond and not take 
4 seconds! I guess there is still work to do. :)

Did you test that with the setting skipExtendToSubpagesChecking=1?

Cheers,
Ernesto