Thank you for your response. Please let us know what happens.
On Friday, October 30, 2020 at 10:21:03 AM UTC-4 jonmiddl...@gmail.com
wrote:
> Thanks for reply - likewise couldn't find any explanation. I'm going to
> try Public IP today but from the docs it suggests Private IP should be
> faster faster, but at least that would rule out any VPC issues that Cloud
> Run doesn't suffer from.
> I'm really not keen to run that configuration in any production capacity
> but it will be interesting to see the results.
>
> Nothing from logs of value - I logged the queries to ensure both APIs on
> both endpoints returning the exact same query, and only have a single Cloud
> SQL DB so they're both getting same row counts. I added OpenTelemetry to
> the app and the pg plugin is showing slower times. I realized in my first
> tests as I'm using an ORM the "query" time was pg time + rehydration so
> wanted to eliminate the rehydration and any CPU bottlenecks being the
> culprit. There may be a bit of that still at play and Cloud Run scaling
> better but the times reported by *opentelemetry-plugin-pg* are double on
> GAE compared to CloudRun.
> Nothing in the logs around dropping, and Cloud SQL load as I'm only in
> testing is low (2% CPU, no spikes)
>
> On Friday, October 30, 2020 at 5:56:24 AM UTC+11 amit...@google.com wrote:
>
>> Hello,
>>
>> By going through the details you provided and relevant documentation for
>> the settings [1,2], I believe the configuration for both are same. During
>> my research, I am yet to find any reason to believe that App Engine takes
>> more time for the connection. Just wondering, are you able to test it using
>> the public IP? Did you find any connection drop from App Engine in the
>> logs?
>>
>> [1]
>> https://cloud.google.com/sql/docs/postgres/connect-app-engine-standard#configuring
>> [2] https://cloud.google.com/sql/docs/postgres/connect-run#configuring
>>
>> On Thursday, October 29, 2020 at 10:20:22 AM UTC-4 jonmiddl...@gmail.com
>> wrote:
>>
>>> Is it expected that AppEngine Standard performs significantly slower
>>> than Cloud Run when a connection to Cloud SQL (Postgres) is involved?
>>>
>>> Testing whether to move away from AWS and which GCP solution to move to
>>> and have fired up instances of Cloud Run and AppEngine to test a NestJS API.
>>> Having added logging to isolate just the time taken to query the DB as
>>> part of an API call, the same GET request that takes 400ms query time on
>>> average in Cloud Run takes 2100ms in AppEngine.
>>> To clarify this is the same source, same build deployed to both and
>>> these are the times once warm so I'm excluding the first few requests.
>>>
>>> For any code not talking to my Cloud SQL instance, i.e. a dummy
>>> javascript method to chew up some CPU time, the performance is more or less
>>> identical
>>>
>>> Cloud SQL, AppEngine and Cloud Run are all set up in the same region
>>> (australia-southeast1), and connection from GAE and Cloud Run to Cloud SQL
>>> is for both via Private IP and Serverless VPC.
>>>
>>> Since I'm in free tier whilst trialing my options, I tried chat support
>>> and basically got down to (verbatim) "cloud run is design to handle data
>>> from apis with cloud sql" while "app engine is recommended for webhosting".
>>>
>>> I'm assuming this is wrong and and a 3-5x slower query performance to
>>> Cloud SQL from GAE isn't an expectation? Any pointers in terms of where
>>> this may be failing?
>>> I haven't yet tried via Public IP and wasn't keen to but I will likely
>>> repeat my tests on both to see if that makes any difference and post my
>>> updates here.
>>>
>>>
--
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/fedb4411-c3c4-42c8-8f14-c8fa65a8fb32n%40googlegroups.com.