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

Reply via email to