I've been watching this for a few days now, holding back, but it's
**awful**! *Please* take a few moments to extract relevant portions from
cited text, definitely do *not* include the whole thing! (There is no
excuse for multiple copies of the footer, usually not an excuse for a
single copy.) For those of us that read via digest mode, at least in some
interfaces, it makes increasingly hard to find messages. I'm taking the
liberty to include one example just to demonstrate the ridiculous length
this has gone.
Ken Manheimer
[EMAIL PROTECTED]
From: "Andy McKay" [EMAIL PROTECTED]
To: "Chris McDonough" [EMAIL PROTECTED],
"Dyon Balding" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope-dev] Tracking memory leak
Date: Wed, 11 Apr 2001 09:35:16 -0700
If you're talking about ZSQLMethod options then its at the default which is
Maximum results to cache 100
Maximum time (sec) to cache 0
Does that mean the first 100 results are being cached for ever? That might
do it...
Cheers.
--
Andy McKay.
- Original Message -
From: "Chris McDonough" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]; "Dyon Balding"
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 8:51 AM
Subject: Re: [Zope-dev] Tracking memory leak
Andy,
Jim just brought something up... do you have database result caching
turned
on? If so, what is your number of max results to cache and max time?
- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: "Dyon Balding" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 7:55 PM
Subject: Re: [Zope-dev] Tracking memory leak
Im not convinced its just SQLAlias though, I commented out the SQLAlias
creations and I was still getting the other object refcounts shooting
up...
Cheers.
--
Andy McKay.
- Original Message -
From: "Dyon Balding" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 4:46 PM
Subject: Re: [Zope-dev] Tracking memory leak
i was one of the people that ran into big problems with that previous
bug.
if that is the one you are coming across, then the problem occurs when
you
try to access the data in a column using a dtml-var with a different
case
to what it is stored in your database.
eg. if you have a column called ID in your database, and do a
dtml-var
id,
then prior to the bug fix, you would see refcount increases for
SQLAlias
(and
possibly some other types as well - can't remember too clearly).
hope that helps you track it down
-d
On Tue, Apr 10, 2001 at 10:25:09AM -0700, Andy McKay wrote:
I have the impression its not SQLAlias thats the problem since im
also
getting Record.Record, Acquistion.ImplicitAcquirerWrapper and
Extension
class floating around. I just commented out the lines that create
SQLAlias
instances and that was fine but...
Sorry you're getting bugged here since you answered my first post.
--
Andy McKay.
- Original Message -
From: "Chris McDonough" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 9:59 AM
Subject: Re: [Zope-dev] Tracking memory leak
I believe it handles the translation of the sql fields from upper
to
lower
and vice versa. More than that, I'm uncertain.
- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]; "Chris McDonough"
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 1:01 PM
Subject: Re: [Zope-dev] Tracking memory leak
Any chance you could clarify what SQLAlias does, ive definitely
got
the
case
where some sql queries (and the way they are handled / used)
causes
an
increase in the SQLAlias count and some dont. Id like to find
the
quick
work
around so I can get around to testing ZmxODBC
Cheers.
--
Andy McKay.
- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: "Chris McDonough" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 8:55 AM
Subject: Re: [Zope-dev] Tracking memory leak
As far as I can tell those changes are still in. Do I
understand
them?
Not
really.
--
Andy McKay.
- Original Message -
From: "Chris McDonough" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 8:37 AM
Subject: Re: [Zope-dev] Tracking memory leak
That's it.
-
