[Zope-ZEO] zope+zodbc+zeo issues
Júlio Dinis Silva
juliodinis@hotmail.com
Wed, 31 Jan 2001 18:46:16 -0000
<html>
<P>Hi,</P>
<P><FONT style="BACKGROUND-COLOR: #ffffff">We are running for some months a zeo-based site where clients have a zodbc connection</FONT></P>
<P><FONT style="BACKGROUND-COLOR: #ffffff">to mssqlserver. We had defined a big value for the clients cache, but recently we drastically decrease that value due to memory problems.</FONT></P>
<P>The problem we are debugging now is that once in a while one of the clients became zombie</P>
<P>and going to a good client and doing the "close zodbc connection" the zombie one start moving ok.</P>
<P>So what is happening here? We think since we decrease the size of our clients cache, activity</P>
<P>in sqlserver is now bigger, so clients request more often sql executions.</P>
<P>We believe there is something wrong having this zodbc object shared by zeo clients where</P>
<P>each one of the clients have a NT ODBC DSN source to the sqlserver.</P>
<P>So question is: is it safe to share the same odbc adapter connection with zeo clients or one should take some special care. We are moving into trying to put each client using each own</P>
<P>zodbc connection. Dont ask me how cause we are going to hit it with a large hammer.</P>
<P>Any comments?</P>
<P>thanx,</P>
<P>Julio Dinis Silva</P>
<P> </P>
<P>ps. sorry if this message goes in html format cause this fuc. hotmail webmail client now</P>
<P>has a activex object that I cant disable.</P>
<P> </P><br clear=all><hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>