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
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.