200,000 keywords.Help needed to get more.

yack09

Newbie
Joined
Jul 6, 2009
Messages
48
Reaction score
2
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.
 
Last edited:

yack09

Newbie
Joined
Jul 6, 2009
Messages
48
Reaction score
2
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.
 
Last edited:

badd

Regular Member
Joined
Jan 22, 2008
Messages
478
Reaction score
92
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.

this is kinda useful buddy. cheers for that
 
Top