it is because of the dollar sign that it works so much quicker.
Scott Hamm wrote:
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
