Welcome to WebmasterWorld Guest from 188.8.131.52 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Pubcon Platinum Sponsor 2014
Problem with LEFT JOIN and big-data table Problem with LEFT JOIN and big-data table us22
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
Those are not very big tables (we regularly deal with tables having 10s of millions of records), so that's not the issue. Make sure your tables are properly indexed- most likely you should have an index on the plateno field on each table. LifeinAsia
Oh, and welcome to Webmaster World [ webmasterworld.com]! :)