[google-cloud-sql-discuss] Re: Connection Pool

How much time is it expected to take to make a new connection? I have an appengine instance on the same region as my second gen cloud sql server and each request takes 300 ~ 1000 ms just to make a connection, which is by far the lengthiest operation in the servlet lifetime.

Em terça-feira, 7 de maio de 2013 18:58:58 UTC-3, Joe Faith escreveu:

Hi Roland

The discussion never ends!

I'd be interested in your use case or requirements.

In particular, since the time to create a new connection is similar to that required to test the liveness of an existing connection, then I'm not sure how a connection pool would help?

j

On Tue, May 7, 2013 at 1:11 PM, Roland Beuker <roland...@arcus-business.com> wrote:

Hello Joe,

Is this the end of this discussion or is Google developing some kind of connection pooling towards Google Cloud SQL?

Regards,

Roland

Op vrijdag 2 maart 2012 18:07:05 UTC+1 schreef Joe Faith het volgende:

Database connections in a cloud hosted environment should be managed differently to those on a conventional server. In particular, be aware that your database instance may be taken offline while not in use, and any pooled connections would be closed. We recommend that a new connection is created to service each HTTP request, and re-used for the duration of that request (since the time to create a new connection is similar to that required to test the liveness of an existing connection).

J

On Fri, Mar 2, 2012 at 1:16 AM, Rémi Bastide <remi.b...@gmail.com> wrote:

Good question ! I'm in need of the answer as well...

Le mardi 1 novembre 2011 19:44:30 UTC+1, javabuddy a écrit :

How to establish Connection Pool in GAE using AppEngineDriver in Cloud
SQL or native datastore??

Thanks

 

 

--
Joe Faith | Product Manager | Google Cloud

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Joe Faith | Product Manager | Google Cloud

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/92bc65eb-17bb-4f52-b075-e44f9cb366a4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.