On Friday 26 June 2009, Brian Troutwine <goofyheadedpunk@gmail.com> wrote:
> CREATE TABLE amazon_items (
> asin char(10) PRIMARY KEY,
> locale varchar(10) NOT NULL DEFAULT 'US',
> currency_code char(3) DEFAULT 'USD',
> isbn char(13),
> sales_rank integer,
> offers text,
> offer_pages integer DEFAULT 10,
> offers_last_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> UNIQUE (asin, locale)
> );
>
Indexes are good things. Try them. Particularly on the isbn field.
--
Overshoot = http://www.theoildrum.com/files/evoltuion_timeline.JPG