Hi,
Thank you for posting your
question on National Instruments' forums.
I guess you are French but
for the sake of the other users of this forum, I will answer in English
(although some of the documents below are in French).
There are a number of differences
between these two engines and this issue has been discussed on the net many
times.
Basically, the engine you
should use depends of the database connection you are making.
I would say that InnoDB
will give you better performances when transferring a large amount of data. A
benchmark made by the people of mysqlperformanceblog.com, a MySQL tuning and
optimization site highlights that InnoDB showed that InnoDB exhibits better
performances that MyISAM (see http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB
for more information).
However, InnoDB is more
complicated to use and requires more memory space to be use adequately than
MyISAM. The data files are also a bit larger when using InnoDB.
Therefore, I would say that
if you are interested only on performances, you should use InnoDB. If you are
seeking an easy to use engine, you should probably use MyISAM instead.
Here are some other links
containing interesting information about InnoDB and MyISAM (in French).
http://www.journaldunet.com/developpeur/tutoriel/out/040511-sql-types-stockage-myisam-innodb.shtml
http://www.tux-planet.fr/mysql-les-principales-differences-entre-myisam-et-innodb/
I hope the above
information will help you.
Best regards,
Guillaume H.
National Instruments France
