Re: [web2py] performance issue- multiple db connection

2010-06-09 Thread Doug Warren
Sorry to bump an old email, but was this changed at some point? (master) [dwar...@thebigwave gluon]$ grep pool_size\= * dal.py:def __init__(self,db,uri,pool_size=0,folder=None,db_codec ='UTF-8'): dal.py:def __init__(self,db,uri,pool_size=0,folder=None,db_codec ='UTF-8'): dal.py:def

[web2py] performance issue- multiple db connection

2010-05-11 Thread vihang
Hello, I am trying to understand the possible performance setback if I try to open multiple db connections. Is there some mechanism in web2py which would optimizes the number of open connections to the database? Vihang

Re: [web2py] performance issue- multiple db connection

2010-05-11 Thread Timothy Farrell
When you create your model, there is a pools parameter that defaults to 10. This means that the one web2py process will use a pool of 10 connections on that one database. It leaves the connections open even after the request is served so that they can serve the next connection without having