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

[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.

Peter.

-- 
Fiat lux! Docendo discimus.
_____________________________
uon GbR

http://www.uon.li
http://www.xing.com/profile/Peter_Russ