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 ============================