Re: [Zope] zodbc performance question
9 Jun
2000
9 Jun
'00
2:48 p.m.
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, but it uses a housekeeping to prevent deadlocks. If you use more connections in the same dtml-document it may lead into the problems. Imagine: connection1:update table connection2:select from table So connection1-object will never know there is an attempt to read from the table after the update. It will however "commit" the write when the document is fully generated. connection2-object will block therefore. HTH Tino Wildenhain
9433
Age (days ago)
9433
Last active (days ago)
0 comments
1 participants
participants (1)
-
Tino Wildenhain