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.