If you only need to use MyISAM for full-text matching,
then use it for
the "searchindex" table, and use InnoDB for the other
Why should I use InnoDB in this case ? I do not plan to use
transactions. Wikipedia tables are only processed / matched on a single
computer with just very few (if any) concurrent connections.
Not considering transactions: What are the main advantages of InnoDB: Is
it faster, is it more stable, is it space-keeping, is it better for
large files/databases like the Wikipedia dumps ... ??
(very interested in your answers..)
CEO EUTROPA AG
Oelmüllerstrasse 9, D-82166 Gräfelfing,
Tel 089 87130900, Fax 089 87130902