Re: Create vs. Remove operation speed.

2017-02-07 Thread 'Shwetha Vastrad (AdWords API Team)' via AdWords API Forum
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.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/fe502112-0955-4c53-8833-979fc7e821d3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: Create vs. Remove operation speed.

2017-02-07 Thread 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.

On Monday, February 6, 2017 at 7:05:04 PM UTC-6, Matthew Wawrin wrote:
>
> 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.
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/f3d9990c-d020-4edc-97c5-b9066a136fc3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Create vs. Remove operation speed.

2017-02-06 Thread 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.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/8557a2a8-244a-4de2-830f-999f81aaa4e2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.