Use InnobDB or MYISAM?

[Daniel Ong]

Hi guys,

i've got a question of whether to use InnobDB or MYISAM
i'm using C++ together with MYSQL to perform a check for new documents

i'm puzzled at which storage engine to use as i know InnobDB is a transaction safe engine but insertion for InnobDB takes a long time

for my application selecting data and inserting data is the primary function. So far i've tried using MYISAM and i've done processing for 10 millions records that takes a day plus. but of course most of the processing work is concerned with C++.

i've got a table that contains documents text, and these text will be retrieved from the table to be processed by C++ for novelty detection. After which i will be inserting the results of this detection into another result table.

i'm not too sure if InnobDB can withstand my load, noting the fact that i might need to insert 10 million rows of data at one go and selecting data from a large table size? in addition, i'm primarily concerned with the speed, meaning i would want the time taken to select and insert data to be minimized