[Zope] zodbc performance question

[Francisco José Esteban Risueño]

I think Zope creates itself a pool of connections to the database,
extending it
when he need more performance. In our installation, we see initially
seven
connection to Oracle (trough ODBC) generated by only one zodbc database
conection
object

Tino Wildenhain escribió:

> Hi Julio,
>
> we tested exactly this approach but run into some deadlock-situations.
> Since it did not improve performance we now use only one
> connection-object
> per database.
>
> Regards
> Tino Wildenhain
>
> julio dinis wrote:
> >
> > Hi all,
> >
> > Using zodbc, supose we have the following situation. One
> > zodbc_database_connection and lots of zsql methods. Can we say that creating
> > more zodbc_database_connection(with a system dsn for each one, but all
> > pointing to the same database) and thus distribute the zsql methods avoiding
> > to all use the same zodbc_connection, will increase performance. Dont tell
> > me I have to test it, I will but some thougts here will help.
> >
> > Best regards,
> > Júlio Dinis Silva
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )