Huston we have a problem:
table1:
purchase_order (primary key)
client_number
buyer_name
table2:
client_number
buyer_number
buyer_name
(all three combine for the primary key for table2)
Query:
select table1.purchase_order, table1.buyer_name,
table2.buyer_number from
table1 inner join table1 on
(table1.buyer_name = table2.buyer_name);
This works, it takes 4 seconds with a limit 50...
but there is over 100,000 records in table1 and over 33,000 records
in table2, so the inner join has to create a temp table with 100,000
X 33,000 records(??? is this right) to do it. = 133mins.
Any info, pointers would be apreciated. Thanks
Simon Buchanan
---- Technical Director -------------------------
New Media Communications http://newmedia.co.nz
Contact: 07 928-3701 mailto:[EMAIL PROTECTED]
-------------------------------------------------
"Endless Loop: n., see Loop, Endless"
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php