DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
EXT: Full-Text MySQL support for indexed_search¶
Author: | Kasper Skårhøj |
---|---|
Created: | 2002-11-01T00:32:00 |
Changed by: | Jose Antonio Guerra Pablos |
Changed: | 2009-06-25T12:42:08 |
Classification: | indexed_search_mysql |
Keywords: | indexed_search, mysql, fulltext, forAdmins, forDevelopers, forIntermediates |
Author: | Jose Antonio Guerra |
Email: | jaguerra@icti.es |
Info 4: | |
Language: | en |
EXT: Full-Text MySQL support for indexed_search - indexed_search_mysql
EXT: Full-Text MySQL support for indexed_search¶
Extension Key: indexed_search_mysql
Language: en
Keywords: indexed_search, mysql, fulltext, forAdmins, forDevelopers, forIntermediates
Copyright 2009, Jose Antonio Guerra, <jaguerra@icti.es>
This document is published under the Open Content License
available from http://www.opencontent.org/opl.shtml
The content of this document is related to TYPO3
- a GNU/GPL CMS/Framework available from www.typo3.org
Table of Contents¶
EXT: Full-Text MySQL support for indexed_search 1
`Introduction 3 <#1.1.Introduction|outline>`_
`Users manual 4 <#1.2.Users%20manual|outline>`_
`Administration 5 <#1.3.Administration|outline>`_
`Configuration 6 <#1.4.Configuration|outline>`_
`Tutorial 7 <#1.5.Tutorial|outline>`_
`Known problems 8 <#1.6.Known%20problems|outline>`_
`To-Do list 9 <#1.7.To-Do%20list|outline>`_
`ChangeLog 10 <#1.8.ChangeLog|outline>`_
Introduction¶
What does it do?¶
Provides support for Full-Text MySQL search. Allows great performance improvements if using MySQL >= 4
This extension packages some of the ideas written in the TYPO3-dev mailing list about using MySQL FULLTEXT search capabilities to optimize “indexed_search” performance, which is pretty low on big websites.
The original threads can be found on:
[TYPO3-dev] Indexed Search Performance Improvement `[3] <http://lists .netfielders.de/pipermail/typo3-dev/2007-February/022302.html>`_ `TYPO3-dev <news://news.netfielders.de:119/mailman.1.1172671573.14329. typo3-dev@lists.netfielders.de>`_
About: Using the FULLTEXT feature of (MySQL) MyISAM tables for indexed_search. (Date: 2-3/2007)
In the basics, this extension modifies “indexed_search” by:
- Adding FULLTEXT indexes to the index_fulltext and index_words tables.
- Changing “LIKE '%...%'” type queries to “MATCH(field) AGAINST(...)”.
Users manual¶
There's no user interaction within this extension.
Administration¶
- Install “indexed_search”
- Ensure you're using MySQL version 4 or higher before installing this.
- Just install “indexed_search_mysql” it from the EM.
The extension will add the needed FULLTEXT indexes to the “indexed_search” tables and will override some functions on allowing to use the FULLTEXT capabilities on MySQL 4.
Configuration¶
This extension has no configuration options.
Tutorial¶
For a quick guide please go to the “Administration” section of this manual.
Known problems¶
The search results effectiveness have not been tested.