200,000 keywords.Help needed to get more.

Hi

I made script that scraps amazon keywords suggestion.
I already scrapped 220,000 keywords. with average 30K per hour and that speed is decreasing. Thats what actually my server takes.

If you have at home, high bandwidth and high ram/CPU, then post a line.
Also if you know how to optimize code and DB then shoot me reply, or if you know who in bhworld can.

Here are 210,000 keywords.
These are not all keywords. There are just pseudo randomly taken starting from seed keyword.


Its mysql dump so you'll probably need to import it with
big dump -> http://www.ozerov.de/bigdump.php

Heres the table structure:
Id like some help to scrap rest of them, and by that i mean someone with high speed bandwidth internet at home and high RAM at least 4GB.

yack09 said:

Here are 210,000 keywords.
These are not all keywords. There are just pseudo randomly taken starting from seed keyword.

Code:

[URL]http://rapidshare.com/files/308169499/210K.zip[/URL]

Its mysql dump so you'll probably need to import it with
big dump -> http://www.ozerov.de/bigdump.php

Heres the table structure:

Code:

CREATE TABLE IF NOT EXISTS `keywords` (
  `KeywordId` int(10) NOT NULL auto_increment,
  `Keyword` char(100) NOT NULL,
  `Exploded` tinyint(1) NOT NULL,
  `Date` datetime NOT NULL,
  `Category` char(60) NOT NULL,
  PRIMARY KEY  (`KeywordId`),
  UNIQUE KEY `Keyword` (`Keyword`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1  ;

Id like some help to scrap rest of them, and by that i mean someone with high speed bandwidth internet at home and high RAM at least 4GB.

Click to expand...

this is kinda useful buddy. cheers for that

badd said:

this is kinda useful buddy. cheers for that

Click to expand...

You're welcomed.