Hi Rob,
If you only need to use MyISAM for full-text matching,
then use it for
the "searchindex" table, and use InnoDB for the other
tables.
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 ... ??
Alex,
http://www.meshine.info
(very interested in your answers..)
Alexander Hölzel
CEO EUTROPA AG
============================
EUTROPA Aktiengesellschaft
Oelmüllerstrasse 9, D-82166 Gräfelfing,
Tel 089 87130900, Fax 089 87130902
============================