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

[Valery Romanchev]

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



--
Best regards,
Valery Romanchev
www.typo3lab.com