Create vs. Remove operation speed.

[Matthew Wawrin]

Hi,

I noticed that during some recent changes to adgroup keywords the batched mutates of the adGroupCriterion to remove existing keywords took much longer than creating new ones.  I was removing about 16 keywords and creating 18 new ones per adgroup.   The create operations took a few seconds to complete per mutate  while to remove took about  a minute and half.  For each adgroup, the remove operations were batched in the same mutate, and the all create operations were batched in the same mutate.

I haven't debugged the timing precisely on my end (there are database delete and inserts for each keyword), but I doubt the difference is on my end.  I'll have more data tomorrow.

Is there a performance difference between create and remove operations in adwords?  

I'll also look at batching all the removes/creates for all adgroups into one mutate for remove and then create, this will result in just two mutate calls, one for remove and one for create, and about 1000 batched operations per. 

Thanks for any insight on speed differences between remove and create. 

Matt.

[Matthew Wawrin]

Hi,

My apologies, this was on our end.  We had a bad index on a table causing the update to the remove operation in our system to take long.  Fixing the index made the remove operation take as much as the set/create operation.

[Shwetha Vastrad (AdWords API Team)]

Hi Matthew,

Glad to hear that you could resolve the issue. If you have any other technical questions about using AdWords API, feel free to post it on this forum.

Regards,
Shwetha, AdWords API Team.