Which Engine to use...

[Scott Hamm]

I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to 
MySQL to learn the migration process and executed the following:

SELECT
*
FROM 
QA
LEFT JOIN 
Batch 
 ON 
Batch.QAID=QA.ID
LEFT JOIN 
QAErrors 
 ON 
QAErrors.ID=Batch.QEID
WHERE 
QA.ID <http://QA.ID> 
 BETWEEN 
'106805' 
 AND 
'107179'
ORDER BY 
QA.ID <http://QA.ID>;

M$ SQL executed and brought up result in 2 seconds
where MySQL took 801 seconds and where
Batch datalength is around 18.5 MB,
QAErrors is around 464KB and
QA is around 3.5MB

Which engine should I use and should I apply to all these tables or?

Batch/QAErrors/QA is most frequent used in database.
-- 
Power to people, Linux is here.