200,000 keywords.Help needed to get more.

Discussion in 'Black Hat SEO' started by yack09, Nov 17, 2009.

  1. yack09

    yack09 Newbie

    Joined:
    Jul 6, 2009
    Messages:
    48
    Likes Received:
    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: Nov 17, 2009
  2. yack09

    yack09 Newbie

    Joined:
    Jul 6, 2009
    Messages:
    48
    Likes Received:
    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: Nov 17, 2009
  3. badd

    badd Regular Member

    Joined:
    Jan 22, 2008
    Messages:
    419
    Likes Received:
    69
    Occupation:
    Innovator
    Location:
    Earth
    this is kinda useful buddy. cheers for that
     
  4. yack09

    yack09 Newbie

    Joined:
    Jul 6, 2009
    Messages:
    48
    Likes Received:
    2
    You're welcomed.