Join Tables and export

[JNunezNYC]

Ok I have 2 tables, one is 6.6 million records and the other varies between 1 to 5 millions records.

Table 1 is a mailing list and table 2 is an imported text file that contains the recordid and a sort id. This file is FTP ( and with a few clients EMAIL?!?! ) to me, I import it and then export a LEFT JOIN of both tables. How can I speed this up without hardware upgrades? Current time for 2 million records... 22+ hours on a 800MHz Duron with 256MB RAM and 80GB HD.

Here is my SELECT:
SELECT cl.sort, ml.*
FROM clientlist AS cl LEFT JOIN mailinglisst AS ml
ON cl.mlistid = ml.mlistid
ORDER BY cl.sort

 

[sleipnir214]

Are cl.mlistid, ml.mlistid, and cl.sort all indexed?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[JNunezNYC]

No they are not... Only ml.mlistid. I could index both cl.mlistid and cl.sort.

Thanks, I'll let you know what the outcome is.