1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    360
    Likes Received:
    51
    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.