Results 1 to 6 of 6
  1. #1
    Full Member
    Join Date
    January 18th, 2005
    Posts
    379
    I am having some difficulty loading a large datafeed (allposters). My host does not have "load data local infile" enabled so I was using a PHP script to insert the CSV.

    The script is really banging the CPU and my host has disabled the account once already.

    I know the answer may be to:
    1) find a new host
    2) get a dedicated

    What I would really like to do is find a script that goes easy on cpu by inserting delays between every 5000 records or something to that effect.

    I don't have shell access on this host.

    I already tried to split the file into 60 smaller files with 50,000 lines in each one.

    Anybody else have any ideas ?

    I may have to use Davids script or webmerge to create static html pages and then upload them.

    Regards,
    Rich

  2. #2
    Affiliate Miester my2cents's Avatar
    Join Date
    January 18th, 2005
    Location
    far far away....
    Posts
    2,161
    ask your host to load the file...

    Joe
    ++++++++++++++++++++++++++++++++++++++++++
    that's my2cents, 'cuz I'm a legend in my own mind....

  3. #3
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    What Joe said. Even if you have to pay them a small fee, it might be worth it.

    A new host would be a good idea too (I know you already said that). A good host will let you do these things and give you shell access too. kualo.com has accounts that work well for affiliates, there are others too. httpme is a good host, but doesn't allow shell access.

    Fred

  4. #4
    Newbie
    Join Date
    January 18th, 2005
    Posts
    3,219
    Sending you a PM

  5. #5
    Animal Lover
    Join Date
    January 18th, 2005
    Location
    oz
    Posts
    1,210
    See my other post Mr Speed which you replied to

    Oscar
    My DataFeed Scripts - php datafeed scripts for your site
    Shareasale datafeed scripts - to display Shareasale datafeeds
    Linkshare datafeed scripts - for multiple Linkshare merchants

  6. #6
    Animal Lover
    Join Date
    January 18th, 2005
    Location
    oz
    Posts
    1,210
    My DataFeed Scripts - php datafeed scripts for your site
    Shareasale datafeed scripts - to display Shareasale datafeeds
    Linkshare datafeed scripts - for multiple Linkshare merchants

  7. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Featured: Datafeed to SQL script? Not price comparison script
    By oxplode in forum Programming / Datafeeds / Tools
    Replies: 19
    Last Post: June 26th, 2014, 02:27 PM
  2. Need Programmer for FTP script, datafeed import script
    By markwelch in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: March 5th, 2007, 04:24 PM
  3. How about a script to monitor server load?
    By TJ in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: January 26th, 2005, 03:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •