#17054Use MySQL fulltext keys in indexed_search
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.