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 to reconnect to the database.
-tim
On 5/11/2010 3:58 AM, vihang wrote:
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