Bug #17054

Use MySQL fulltext keys in indexed_search

Added by Peter Russ over 14 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Should have
Category:
Indexed Search
Target version:
-
Start date:
2007-02-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.7
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)


Files

class.tx_indexedsearch.php.diff (1.72 KB) class.tx_indexedsearch.php.diff Administrator Admin, 2007-02-28 14:54
indexed_search_fulltext.diff (78.4 KB) indexed_search_fulltext.diff Administrator Admin, 2008-11-08 20:09
indexed_search_fulltext_4-2.diff (108 KB) indexed_search_fulltext_4-2.diff Administrator Admin, 2008-11-08 20:17

Also available in: Atom PDF