how big is this ad database table?

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)?

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:

the current (first) update is takes now > 1 hour for the first 1000 records :D

... 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) :(

edit try it now via SSH...

abort :(

get this error after the import of ~1000 records:

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

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

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?

check this http://www.google.com/search?q=glibc+detected+***+double+free+or+corruption

I think it's php5 related...

:( I don't have a php4 host anymore...

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?

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.

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

Nick, an please send me your database dump (.gz)

Ok I will do a little later :)

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

Lewis I am afraid this is not possible as there is no way to download a part of CB's database.