[Zope] zodbc performance question

2000-06-09 Thread julio dinis
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

Re: [Zope] zodbc performance question

2000-06-09 Thread Tino Wildenhain
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

Re: [Zope] zodbc performance question

2000-06-09 Thread 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

Re: [Zope] zodbc performance question

2000-06-09 Thread Tino Wildenhain
Francisco José Esteban Risueño wrote: 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 Yes,