Issue Bug Closed

#17054Use MySQL fulltext keys in indexed_search

Peter Russ 02/28/07, 14:54 updated 10/02/18, 12:32

Description

It takes several 10s of seconds to get serach result displyed.
The problem is the “fulltext” search on a regular index either on index_fulltext.fulltext or on index_words.baseword performed by a like ‘nonsense’ query.

We could speed up the time (10s of sec down to millisec) by do the following:
1) adding fulltext index to index_fulltext.fulltext and index_words.baseword
2) changed query in class.tx_indexedsearch.php to use fulltext capabilites of MySql.

Limitation: requires newer versions of MySql (4.0 or later)

Find diff for latest 4.0.5 attached

(issue imported from #M5089)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.