Welcome to WebmasterWorld Guest from 126.96.36.199 , register , login , search , subscribe , help , library , PubCon , announcements , recent posts , open posts Subscribe to WebmasterWorld
Problem with LEFT JOIN and big-data table Problem with LEFT JOIN and big-data table us22 msg:4049530 4:49 am on Dec 26, 2009 (gmt 0) Hello,
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
LifeinAsia msg:4050362 5:16 pm on Dec 28, 2009 (gmt 0)
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 msg:4050363 5:18 pm on Dec 28, 2009 (gmt 0)
Oh, and welcome to Webmaster World [ webmasterworld.com]! :)