Re: [Zope] Zope eating CPU/RAM - how do I find the culprit?
If you are using ZSQLMethods and your database returns column names in one case (UPPER) but you reference them with another (lower) it appears that instances of SQLAlias get leaked. Brian Lloyd has put Jim Fulton's fix in the 2.2.5b release that's up on the site. We were seeing thousands of leaked instances of SQLAlias causing our memory usage to skyrocket. -jon cg@cdegroot.com (Cees de Groot) writes:
Jon Prettyman <jprettyman@acm.org> said:
Are you using ZSQLMethods by any chance?
Yes, why? (I think I've fixed /this/ problem, but if ZSQLMethods will cause similar behaviour I'd like to be prepared :-))
--
Jon Prettyman <jprettyman@acm.org> said:
If you are using ZSQLMethods and your database returns column names in one case (UPPER) but you reference them with another (lower) it appears that instances of SQLAlias get leaked.
Thanks for the info (and another reason to keep SQL names in lowercase ;-)). -- Cees de Groot http://www.cdegroot.com <cg@cdegroot.com> GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B
participants (2)
-
cg＠cdegroot.com -
Jon Prettyman