[TYPO3-dev] Indexed search slow with 2500 news records. Possible solution

[Martin Kutschker]

Valery Romanchev schrieb:
> Hello
> 
> I see 2 reports, that indexed search is slow with 1000-2000 records
> I confirm this.
> I have site with 2500 tt_news records indexed by creawler
> (utf8, Russian language).
> 
> Search speed - from 25 sec.
> 
> index_phash   2,529   1.1 MB
> index_rel 918,641  37.6 MB    
> index_words 97,229      7.2 MB      
> 
> I think the solution of irrelevant search speed can be to make simple 
> search extension with the usage of  MySQL FULLTEXT for 
> index_fulltext.fulltextdata
> 
> I have experience with FULLTEXT for http://www.vostock-photo.com
> The search speed was improoved from 30 sec to 3-8 sec
> For example:
> 
> SELECT distinct items.*
> FROM items, sections, items_sections_mm
> WHERE
> MATCH (keywords) AGAINST ( '+woman +man +(cat dog) -god -bench' IN 
> BOOLEAN MODE )
> ....
> works with 2-4 sec on 170000 records in items table

Now with DBAL this is not a real option for the main code. Perhaps the 
indexed search can be modified to sport hooks for DB specific optimizations.

Masi