Fwd: [Zope-ZEO] zope+zodbc+zeo issues

Fri, 02 Feb 2001 22:26:45 -0000

This is a multi-part message in MIME format.

------=_NextPart_000_7b17_26fd_2c5e
Content-Type: text/plain; format=flowed

>From: "Júlio Dinis Silva" <juliodinis@hotmail.com>
>To: zope-zeo@zope.org
>Subject: [Zope-ZEO] zope+zodbc+zeo issues
>Date: Wed, 31 Jan 2001 18:46:16 -0000
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

------=_NextPart_000_7b17_26fd_2c5e
Content-Type: message/rfc822

>From zope-zeo-admin@zope.org Wed Jan 31 10:54:14 2001
Received: from [209.67.167.110] by hotmail.com (3.2) with ESMTP id MHotMailBC41AA4F005CD820F39AD143A76E10730; Wed Jan 31 10:54:07 2001
Received: from www.zope.org (localhost [127.0.0.1])
	by zope.codeit.com (8.8.7/8.8.7) with ESMTP id KAA06334;
	Wed, 31 Jan 2001 10:43:24 -0800
Received: from hotmail.com (f5.law4.hotmail.com [216.33.149.5])
	by zope.codeit.com (8.8.7/8.8.7) with ESMTP id KAA06297
	for <zope-zeo@zope.org>; Wed, 31 Jan 2001 10:43:18 -0800
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Wed, 31 Jan 2001 10:46:16 -0800
Received: from 194.65.14.68 by lw4fd.law4.hotmail.msn.com with HTTP;	Wed, 31 Jan 2001 18:46:16 GMT
X-Originating-IP: [194.65.14.68]
From: "Júlio Dinis Silva" <juliodinis@hotmail.com>
To: zope-zeo@zope.org
Subject: [Zope-ZEO] zope+zodbc+zeo issues
Date: Wed, 31 Jan 2001 18:46:16 -0000
Mime-Version: 1.0
Content-Type: text/html
Message-ID: <F5LTkUD5euwdUTaGmvS00002884@hotmail.com>
X-OriginalArrivalTime: 31 Jan 2001 18:46:16.0886 (UTC) FILETIME=[17F8BD60:01C08BB6]
Sender: zope-zeo-admin@zope.org
Errors-To: zope-zeo-admin@zope.org
X-Mailman-Version: 1.0b8
Precedence: bulk
List-Id: Discussions of Zope Enterprise Option <zope-zeo.zope.org>
X-BeenThere: zope-zeo@zope.org

<html>
Hi,
We are running for some months a zeo-based site where clients have a zodbc connection
to mssqlserver. We had&nbsp; defined a big value for the clients cache, but recently we drastically decrease that value due to memory problems.
The problem we are debugging now is that once in a while one of the clients became zombie
and going to a good client and doing the &quot;close zodbc connection&quot; the zombie one start moving ok.
So what is happening here? We think since we decrease the size of our clients cache, activity
in sqlserver is now bigger, so clients request more often sql executions.
We believe there is something wrong having this zodbc object shared by zeo clients where
each one of the clients have a NT ODBC DSN source to the sqlserver.
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
zodbc connection. Dont ask me how cause we are going to hit it with a large hammer.
Any comments?
thanx,
Julio Dinis Silva
&nbsp;
ps. sorry if this message goes in html format cause this fuc. hotmail webmail client now
has a activex object that I cant disable.
&nbsp; <hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>. </html>

_______________________________________________
Bug reports, feature requests, etc. go in the ZEO Tracker:
http://www.zope.org/Products/ZEO/Tracker

Conversations etc. can take place in the Wiki:
http://www.zope.org/Products/ZEO/Wiki

Zope-ZEO maillist  -  Zope-ZEO@zope.org
http://lists.zope.org/mailman/listinfo/zope-zeo

------=_NextPart_000_7b17_26fd_2c5e--