[TYPO3-dev] faults in table-creation for index_fulltext and index_words

[David Bruchmann]

Am 07.10.2010 00:33, schrieb Peter Russ:
> --- Original Nachricht ---
> Absender: Dmitry Dulepov
> Datum: 06.10.2010 12:17:
>> Hi!
>>
>> David Bruchmann wrote:
>>> for the tables index_fulltext and index_words there is a FULLTEXT
>>> defined but FULLTEXT exists only for MyIsam-Tables and the tables are
>>> InnoDB.
>>
> [..]
>>> Is it better now to change to MyIsam or to run them without FULLTEXT?
>>
>> No. InnoDb there is for performance reasons. Taking it out will block all
>> visits to page when indexed search updates indexes.
>>
>
> To make it clear: indexing pages while people visit them is the 2nd best
> option.
> IF you HAVE to use indexed_search and you are interested in delivering
> results in seconds and not in minutes you will definetly find a way to
> ran a cron when there is low traffic and go for MyIsam and FULLTEXT.
> With plain InnoDB there is no way to deliver results as fast as FULLTEXT
> on a plain MySql-Server.
>
> By the way: the original patch for that was not from Stucki ;-)
> Also TYPO3 is GPL it would be nice to respect authorship.


Thanks a lot for the info.
Never verified those things by myselfe.

Greets,
David