MySQL would eventually finish that query, but it's a big. You are
joining every record in one database with every record in another,
except where the id's match. You would probably end up with a result
set of 499,000 records, assuming there is a one to one match with ids.
What you want to do is
I'm looking for a way to select data from one table that is not found in
another. I am sorting on a column called 'model_id'. Basically I want
something like this to work:
"SELECT t1.*, t2.model_id FROM data1 as t1, data2 as t2 WHERE
t1.model_id != t2.model_id"
t1 has about 1000 entries and t
