16, March 2010

how big is this ad database table? - webmaster forum

 
Webdigity webmaster forums
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  WebDigity Community  >  HumanWorks network news & feedback  >  Clickbank Contextual Script Support
Topic: how big is this ad database table?		 « previous next »
Pages: [1] Print

Author Topic: how big is this ad database table?  (Read 2158 times)
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« on: Sep 04, 2007, 01:28:15 pm »
Hello,

I'm just updating my database and it takes some time.

what is a normal number of records (ads)

and about CB, are these ads mostly for people from the US (target group)?
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Internet Junkie
*****
Gender: Male
Posts: 1807
9006 credits
Members referred : 6
« Reply #1 on: Sep 04, 2007, 01:55:20 pm »
Clickbank has a little over 20,000 products, so thats about how many records you should have.
free PHP scripts and PHP tutorials | The Big Adsventure |  Lets Work Online! | 43 Proxies

Last blog : Are You Stumbling Yet?
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #2 on: Sep 04, 2007, 02:18:11 pm »
Quote from: Mind_nl on Sep 04, 2007, 01:55:20 pm
Clickbank has a little over 20,000 products, so thats about how many records you should have.

lol maybe nick should change this text for the CBC scripts:
Quote
Alterativelly you can update manually the database by clicking the button bellow. The process may take a few minutes. Be sure to press it only once. Some times

the current (first) update is takes now > 1 hour for the first 1000 records Cheesy
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #3 on: Sep 04, 2007, 02:48:47 pm »
... vert strange 20K ads provided by the xml file, the import file will empty the table first.

will say I have to import the whole 20K records every night?

It takes a lot of time because ... last time the import script has stopped working after 1000 records (2 hours work) Sad

edit try it now via SSH...
« Last Edit: Sep 04, 2007, 02:50:50 pm by Olaf »
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #4 on: Sep 04, 2007, 03:03:18 pm »
abort Sad

get this error after the import of ~1000 records:

*** glibc detected *** double free or corruption (!prev): 0x08946808 ***
Aborted
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #5 on: Sep 04, 2007, 05:02:23 pm »
The update should be done once per month. There is no reason to do it every day or even week.

Olaf, this error looks like a memory related error. Do you use CLI or web to update? Do you have curl enabled?
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #6 on: Sep 04, 2007, 05:33:15 pm »
Quote from: Nikolas on Sep 04, 2007, 05:02:23 pm
The update should be done once per month. There is no reason to do it every day or even week.

Olaf, this error looks like a memory related error. Do you use CLI or web to update? Do you have curl enabled?

yes, downloading the file is fine. then it works fine for the first 700-2000 records and then I got this via CLI, via the web it stops working
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #7 on: Sep 04, 2007, 07:44:59 pm »
I believe this is a problem of your host (another client had this too)

If you can't reach a good ammount of records then I can send you the mysql dump.
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #8 on: Sep 04, 2007, 08:47:55 pm »
Quote from: Nikolas on Sep 04, 2007, 07:44:59 pm
I believe this is a problem of your host (another client had this too)

If you can't reach a good ammount of records then I can send you the mysql dump.

yes please send me the dump, do you think I should give the script more memory?
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #9 on: Sep 04, 2007, 08:51:37 pm »
check this http://www.google.com/search?q=glibc+detected+***+double+free+or+corruption

I think it's php5 related...

Sad I don't have a php4 host anymore...
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #10 on: Sep 05, 2007, 12:08:21 am »
just noticed that it work fine with import script from the prev. version, how is this possible?
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #11 on: Sep 05, 2007, 10:25:38 am »
Quote from: Olaf on Sep 05, 2007, 12:08:21 am
just noticed that it work fine with import script from the prev. version, how is this possible?

The previous version is not using curl to fetch data from the vendor sites, so the process is much faster.
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #12 on: Sep 05, 2007, 10:49:30 am »
Quote from: Nikolas on Sep 05, 2007, 10:25:38 am
Quote from: Olaf on Sep 05, 2007, 12:08:21 am
just noticed that it work fine with import script from the prev. version, how is this possible?

The previous version is not using curl to fetch data from the vendor sites, so the process is much faster.

why do you fetch these data?
is the XML information not enough?
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #13 on: Sep 05, 2007, 11:30:25 am »
The xml information has a lot of ads that target affiliates, not the actual buyers.

But as the update takes a lot of time, I think we are going to change the whole thing in the next version with a central update service.
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #14 on: Sep 05, 2007, 11:47:18 am »
Ok I understand.

I get 5890 ads with old script, I think if the update need to be done only onth a month it should be OK.

maybe it takes so much time here because I'm in some dutch network with this server
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
Global Moderator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 6690
34708 credits
Members referred : 374


It's time to use PHP5!
« Reply #15 on: Sep 05, 2007, 11:48:03 am »
Nick, an please send me your database dump (.gz)
Website Monitoring Service

Free WordPress Themes
Magento Templates

Last blog : A new Wordpress theme for our blog
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #16 on: Sep 05, 2007, 12:27:01 pm »
Ok I will do a little later Smiley
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Chicken-run Manager
*
Posts: 9
62 credits
Members referred : 0
« Reply #17 on: Sep 11, 2007, 08:12:33 pm »
Is it possible since I am only interested in one fitness category to make the contextual ads system just work with the one category ? It would speed up the entire process for me.

reagrds
Lewis
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 5659
45587 credits
Members referred : 3
« Reply #18 on: Sep 12, 2007, 10:49:16 am »
Lewis I am afraid this is not possible as there is no way to download a part of CB's database.
Trial and Error my two best teachers Cool
Join us @ facebook or twitter

Last blog : Butterfly Marketing 2.0
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=7070
Tags : database ads Bookmark this thread : Digg Del.icio.us Dzone more....

Pages: [1] Print 
Webdigity Webmaster Forums  >  WebDigity Community  >  HumanWorks network news & feedback  >  Clickbank Contextual Script Support
Topic: how big is this ad database table?		 « previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
Mar 16, 2010, 12:35:49 pm





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!


Forum Statistics
Total Posts: 44.172
Total Topics: 8.615
Total Members: 8.209
Tutorials : 58
Resources : 929
Designs : 360
Latest Member: lisactrytoo

40 Guests, 4 Users online :

20 users online today:

Recent topics
Re: hosting with a discount...
Re: aspnix vs 7host
Re: Scanning website files...
Re: help needed! Laptop DVD...
Re: Anyone used Vista?...
Re: what the pr mean to my ...
Re: The 100 Lists Website D...
Re: Re: Some good reasons t...

HumanWorks Network
Technology news
Webmaster articles
Sublime web directory
RSS Feed directory and viewer

Readers

Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2010 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.