Re: Speed problem on large tables

[Dan Holdway]

Doh... The other table definition should have been;

CREATE TABLE `site_amazon_items` (
`Site_Amazon_Product_ID` int(11) NOT NULL auto_increment,
`Amazon_Product_ID` int(11) NOT NULL default '0',
`Site_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`Site_Amazon_Product_ID`),
UNIQUE KEY `Site_Amazon_Product_ID` (`Site_Amazon_Product_ID`),
UNIQUE KEY `Site_ID` (`Site_ID`,`Amazon_Product_ID`),
KEY `Amazon_Product_ID` (`Amazon_Product_ID`)
) TYPE=InnoDB