MySQL Forums
Forum List  »  Newbie

Mysql performance on large joins (its bad)
Posted by: beau
Date: March 15, 2005 07:27PM

Mysql is unable to perform joins with large tables ON VARCHAR.

these joins run fine when the queriers are performed on INT values. However int values are not practical in this instant because I am joining on product SKUs.

sample SQL
-----------------
SELECT a.sku AS this, b.sku AS that, b.price, b.SRP
FROM table1 a
INNER JOIN table2 b
ON a.sku LIKE b.sku

TABLE specs
-------------------------
table1 14000 records
table2 13000 records

Running Mysql 4.1, PHP 4.3

any advice is appreciated.
-Beau

Options: ReplyQuote


Subject
Written By
Posted
Mysql performance on large joins (its bad)
March 15, 2005 07:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.