On Mon, Mar 3, 2008 at 8:26 PM, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > On Mar 3, 2008, at 9:17 PM, Lukasz Szybalski wrote: > > > What is the proper connection string for sqlalchemy to support > > pool_recycle? > > Is there a setting in mod_Wsgi to support this? > > its a create_engine option, so its a keyword argument - i.e > create_engine(url, pool_recycle=3600). > > I didnt think mod_wsgi had any kind of database integration, but your > slice of code looked like you had a config file going on. If the > config system is using SA's engine_from_config() function, you'd add > "sqlalchemy.pool_recycle" to your config file. > >
I'll add sqlalchemy.pool_recycle = 3600 to my prod.cfg (turbogears) How is the pool recycle going to affect performance? It seems to me that if 1000 people hit my website it will open 1000 connection to mysql. Assuming limiter number of connections my website will shut down. How does that change with pool_recycle? What happens sqlalchemy to mysql connections if if I set: server.thread_pool = 30 Lucas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---