Re: [sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
On Fri, Nov 16, 2018 at 8:20 AM wrote: > > Hi, > My connection timeout happening after 30 seconds even if I set the > pool_timeout=3600. My create engine code is written below > I want set custom pool_timeout value. But its not working as per the > expectation. My create_engine code is written below > > def _dbconnect(self, connstr, ps=20, ds_timeout=3600): > # simple sql alchemy connection. > return create_engine(connstr, pool_size=ps, echo=False, > poolclass=QueuePool, pool_timeout=ds_timeout) timeout is how long the pool will spend waiting for a connection to be available if all the connections in the pool are in use. it seems unusual you'd want to set this to 3600 seconds, are you confusing "timeout" with pool_recycle ? > > > Please help. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
[sqlalchemy] connection timeout happens after 30 sec even if set the pool_timeout=3600
Hi, My connection timeout happening after 30 seconds even if I set the pool_timeout=3600. My create engine code is written below I want set custom pool_timeout value. But its not working as per the expectation. My create_engine code is written below def _dbconnect(self, connstr, ps=20, ds_timeout=3600): # simple sql alchemy connection. return create_engine(connstr, pool_size=ps, echo=False, poolclass=QueuePool, pool_timeout=ds_timeout) Please help. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Caching intermediate results in baked queries
On Thu, 15 Nov 2018 at 16:41, Mike Bayer wrote:
> >
> > But then you lose the benefits of the cache, and the Bakery is only
> useful if you use the same Querys over and over. Unless I've completely
> misunderstood how it works.
>
> well the "anonymous" bindparam() still has a name. you just use that
> name, and it gets converted to the "real" name when the statement is
> executed:
>
> >>> from sqlalchemy import *
> >>> b1 = bindparam(None)
> >>> b1.key
> '%(140062366895800 param)s'
> >>> s1 = select([b1])
> >>> print(s1)
> SELECT :param_1 AS anon_1
> >>> s1.compile().construct_params({'%(140062366895800 param)s': 5})
> {'param_1': 5}
>
>
>
Ah, understood. That's a pretty neat trick actually, might see if we can
incorporate that somewhere.
Thanks.
Have a nice day,
--
Martijn van Oosterhout http://svana.org/kleptog/
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
