[Typo3-dev] indexed_search - Performance Issue Questions

[Jens Liesegang]

On 23.11.2005 12:16 Uhr, in article
mailman.1.1132744598.28427.typo3-dev at lists.netfielders.de, "Michael
Schaller" <mic at micweb.de> wrote:

> Jens Liesegang schrieb:
>> On 14.11.2005 14:34 Uhr, in article
>> mailman.1.1131975296.12081.typo3-dev at lists.netfielders.de, "Dmitry Dulepov"
>> <typo3 at fm-world.ru> wrote:
>> 
>> 
>>> Hi!
>>> 
>>> Georg Kuehnberger wrote:
>>> 
>>>> Questions:
>>>> ============
>>>> - indexed_search - Tuning:
>>>>    Does/Did anybody experience similar performance-issues with
>>>> indexed_search in general; not within the indexing-process though the
>>>> search and especially the above mentioned function & how did you solve
>>>> them?
>>> 
>> We had performance issues as well. After investigating the source we change
>> the default search type from 1 to 20. After this every search was fast and
>> mysql did not produce high server load.
>> 
>> 
> 
> Hello,
> 
> as far as i remember search type 20 is the one without indexing (the
> full text search). Sounds strange to me you get better performance with
> that type. On our site search type 20 (search for a sentence) is a real
> mysql killer.
> mysql-slow.log shows only queries of the 'sentence search' (search
> string between quotes) sometimes about 450 sec. on a dual xeon Webserver.
> I'm going to filter the quotes of the search string and disable the
> sentence search.
> 
> Michael
Hello Michael,

Sorry but this is our experience. If you would like to examine this in our
production environment pls. Contact me via pm. We use a dual xeon server too
to serve around 3.000 visitors per day and appr. 50.000 pages and our search
page is one of the most requested.

Jens