Hi Juan It is actually not slow from my local machine but slow from an Google App Engine nodejs application running in the same region. If I do the same things from my local machine or Glitch it works fine but from the GAE app it is very slow.
Thanks Leonard On Mon, Jul 13, 2020 at 11:13 AM 'Juan Carlos Gomez' via Google App Engine < [email protected]> wrote: > Hello, > > Thank you for your post. I understand that you have a Cloud SQL instance > and Cloud Storage bucket in the us-central region and the access to both of > this servers from your local machine is slow. > > This could be for many reasons external to the Cloud Platform scope such > as: > + Temporary bad ISP bandwidth. > + Another application(s) in your local machine are using the network > bandwidth and it taking the larger part of it. > + Another application(s) is using to much CPU power which is slowing the > connection processes to your GCP resources. > + other local network issues. > > There was no known incident related to this as it can be seen in [1] > > In order to help you further I would suggest that you consider all the > other possibilities. And then, check with the gsutil tool to check the > speeds with the a standard tool. > > [1] https://status.cloud.google.com/ > > On Friday, July 10, 2020 at 6:32:48 PM UTC+2, Leonard Cremer wrote: >> >> Problem you have encountered: >> When I download a 83kb file from cloud storage it takes between 5 and 12 >> seconds where from my local machine it takes between 2 and 5 seconds. >> My cloudSQL inserts are also much slower than when tested from another >> server to CloudSQL so it seems to be related. >> >> What you expected to happen: >> I expect this to be very fast as it is both on the us-central servers >> >> Steps to reproduce: >> let filename = `${routeKey}.json.gz`; >> logger.info >> <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, >> `filename:${filename}`); >> const file = storageBucket.file(filename); >> logger.info >> <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, >> `have file:${filename}`); >> const [contents] = await file.download() >> logger.info >> <https://www.google.com/url?q=http://logger.info&sa=D&usg=AFQjCNGZLuTewKKCnjSHOj9PNrqzV_CnFw>(loggerKey, >> `downloaded:${filename}`); >> >> Other information (workarounds you have tried, documentation consulted, >> etc): >> Here is my stackdriver logs linked to the code above. The download step >> takes 12 seconds in this instance. >> I 2020-07-10T08:18:15.188999891Z >> downloaded:159414332187374700443664:ATL:BRU:economy.json.gz >> I 2020-07-10T08:18:03.111999988Z have >> file:159414332187374700443664:ATL:BRU:economy.json.gz >> I 2020-07-10T08:18:03.111000061Z >> filename:159414332187374700443664:ATL:BRU:economy.json.gz >> I 2020-07-10T08:18:03.111000061Z Starting processSkyJSONFile >> > -- > You received this message because you are subscribed to a topic in the > Google Groups "Google App Engine" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-appengine/wm9l1i3jeRU/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-appengine/cacf578f-9861-48fa-b09a-d72a2579bf6eo%40googlegroups.com > <https://groups.google.com/d/msgid/google-appengine/cacf578f-9861-48fa-b09a-d72a2579bf6eo%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- *Leonard Cremer* Founder Johannesburg, South Africa M (+27) 83 454 2522 E [email protected] <[email protected]> W trooptravel.com <https://www.linkedin.com/company/trooptravel> <https://www.facebook.com/trooptravel/?hc_ref=ARQBW1Sh4xfNXzSin0DwN2bJZXAun41snzJEDkx2DLGiC8ttgPumn_RkSpDRquimk2g&fref=nf&__tn__=kC-R> -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/CAJt8yRK3ZDSmSg1wzN2WkQS9uOHyuH%2Bfg83CppsrzfSoR7vpeQ%40mail.gmail.com.
