I have been running tests the last couple of weeks. Unfortunately, as I do not have a snapshot of what throughput we used to get earlier, all I have been trying with is different settings: GZIP, no-GIP, different download formats (as reported in another thread), but nothing seems to affect performance. Our reports have become slower significantly since around September 7th. I would highly appreciate if someone could help us with this - we can keep increasing the parallelism, but that is not the way we want to go - we'll stress the API system, and likely run into rate issues. I am happy to share any details that might help with the technical investigation. At a scale of thousands of accounts, the speed difference really makes a difference.
@Dorian, do you use TSV format by any chance? I keep suspecting that it is something to do with TSV format reports, but I am not able to prove it in experiments with a hundred or so reports. Regards, MG On Thursday, September 28, 2017 at 7:12:06 PM UTC+5:30, Dorian Kind wrote: > > Hello, > > FWIW, we also have experienced somewhat of a performance degradation in > the reporting infrastructure. > > We have one job in particular that collects a number of KPIs and > structural data for a few hundred accounts using non-AWQL report > definitions, and up until September 7th its run time was always in the > order of ~200 minutes. Starting from September 8th however, this job now > takes more than double that time, usually between 400 and 500 minutes for > the same number of accounts. It's not a problem for us as the functionality > is not time-critical, but it definitely became slower. > > The timing suggests that it could be the same issue as described > by AdWordsApiUser in the original post. > > Best regards, > Dorian > > On Wednesday, 27 September 2017 14:38:11 UTC+2, Michael Cloonan (AdWords > API Team) wrote: >> >> Hello, >> >> No changes were made that should affect reporting speed, so I have some >> followup questions to see if we can determine the root cause here. >> >> - Is this across all report types, or is there a specific report type >> where you're seeing the slower behavior? >> - Do you see more rows get returned or anything else changed in the >> content of the reports? >> - For a single report, how long did it take previously and how long does >> it take now? >> >> Regards, >> Mike, AdWords API Team >> >> On Tuesday, September 26, 2017 at 8:02:13 AM UTC-4, Michael Cloonan >> (AdWords API Team) wrote: >>> >>> Hello, >>> >>> No updates yet. I will follow up with the team to see what they've found >>> so far. I will post here when I have any information to share. >>> >>> Regards, >>> Mike, AdWords API Team >>> >>> On Tuesday, September 26, 2017 at 5:00:47 AM UTC-4, AdWordsApiUser wrote: >>>> >>>> Any updates on this? Thanks! >>>> >>>> On Thursday, September 21, 2017 at 12:32:37 PM UTC+5:30, AdWordsApiUser >>>> wrote: >>>>> >>>>> I saw this new thread mentioning the slowdown in TSV reports - we use >>>>> TSV reports exclusively - probably that is the issue - >>>>> https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!topic/adwords-api/lnuRYUwohNw >>>>> >>>>> A swift resolution will be appreciated :-) >>>>> >>>>> MG >>>>> >>>>> >>>>> On Tuesday, September 19, 2017 at 8:04:09 PM UTC+8, Michael Cloonan >>>>> (AdWords API Team) wrote: >>>>>> >>>>>> Hello, >>>>>> >>>>>> No, that will not be necessary; you specifically specified AWQL so I >>>>>> wanted to know if you had done any tests narrowing that down. >>>>>> >>>>>> When you say your "job", you mean that your job runs multiple reports >>>>>> that, in aggregate, used to take 8 hours and now take 16, right? It's >>>>>> not a >>>>>> single report taking that long? >>>>>> >>>>>> I will pass along the details you sent privately to our engineering >>>>>> team to investigate in the meanwhile. >>>>>> >>>>>> Regards, >>>>>> Mike, AdWords API Team >>>>>> >>>>>> On Monday, September 18, 2017 at 5:53:21 PM UTC-4, AdWordsApiUser >>>>>> wrote: >>>>>>> >>>>>>> Hi Michael, >>>>>>> >>>>>>> Thanks for your reply. We only use AWQL styled queries, so I don't >>>>>>> know right now if that could be the reason. Do you suggest that we try >>>>>>> using the definition styled reports and compare performance? As I >>>>>>> mentioned earlier, my job that used to get over in 8 hours now takes 16. >>>>>>> >>>>>>> Cheers, >>>>>>> MG >>>>>>> >>>>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/4d1d14e5-35e2-4257-a8b4-19c1abfc7fbc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
