I have problem wtih make left join query in tow big table
the first one have more then 10,000 records

and second table have more then 35000 records

i make query below:

SELECT table1.code, table1.siteaddress, table1.plateno, table2.plateno FROM table1 JOIN table2 ON table1.plateno=table2.plateno LIMIT 1,10;

that query retrieve a good result but it's took long time to do that

and in my php interface i lost connection with server and also the result.

any one can help me.

NOTE: sorry my English is weak