Re: Speed problem on large tables

[Dan Holdway]

Hi Mike,

Thanks for the response!

Here's the output you requested - Sorry about the format, but it's the only way I could figure out how to post it. :-/


table.......................| type ....| possible_keys
--------------------------------------------------------------------------------
site_amazon_items....| ref ......| Site_ID,Amazon_Product_ID
Amazon_Items .........| eq_ref .| PRIMARY,Amazon_Product_ID,Product_Key_Letter



key ........| key_len ..| ref ......................................................| rows............| Extra
--------------------------------------------------------------------------------------------------------------------------------------------
Site_ID ...| 4 ..........| const ...................................................| 221,960.000 | Using where; Using index; Using temporary; Using filesort
PRIMARY | 4 ..........| site_amazon_items.Amazon_Product_ID .| 1.000............|


Any light that you could shed would be most appreciated!

Dan