Optimize performance
For larger TYPO3 projects (from approx. 500-1000 pages) the search speed of indexed_search increases significantly. It can take 30-60 seconds until a search result is available.
This is not only annoying for the website visitor but also places a heavy load on the MySQL server. This affects the performance of the entire site.
The cause is trivial, as is the solution to the problem: indexed_search creates a word list in the database. This can contain several 100,000 entries. By default, partial word search is activated in the extension. This means that a search for "schwein" also returns results that contain the word swine flu, for example, but not the individual term schwein. For this to work, the entire word list must be searched with the database query
WHERE ... LIKE '%search term%'
must be searched. In this case, the indexed search for this table becomes a full-text search - and this takes considerably longer.
The solution:
With the TypoScript instruction
plugin.tx_indexedsearch._DEFAULT_PI_VARS.type = 0
the search is configured for a whole-word search. If required, the visitor can still switch to a partial word search using the "advanced search" option. The search speed can be increased by a factor of 10-30 with this simple setting.
This page contains automatically translated content.