[TYPO3-dev] TYPO3 4.1 INNODB

[R. van Twisk]

Dmitry Dulepov wrote:
> Hi!
>
> R. van Twisk wrote:
>   
>> If you read the thread '[TYPO3-dev]  Indexed Search Performance 
>> Improvement' people are finding
>> a way to improve indexed search using full text indexes. However full 
>> text search doesn't work on
>> innodb, something to take into consideration.
>>     
>
> Only some tables were changed to InnoDB, not all.
>
>   
>> I am not sure if indexed search operates on it's own tables, or that it 
>> works on other tables.
>>     
>
> Uses own tables...
>
>   
Then using innodb whereever possible is good,
I would also opt for myisam for indexed search and
using full-text index for mysql databases.

The number of ppl using other databases is so small
that I we can justify the majority. Hereby I assume
that for other databases we fall back on that current search method
(not using FT), and loose some speed.


Ries