-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/27/2011 11:12 AM, Tres Seaver wrote:
> The "aliases" feature of the stock Shared.DC.ZRDB.Results.Results class > has a leak, due to an uncollectable cycle created between the alias > objects and the record class generated *for each query*. If your app > makes heavy use of stock ZSQL methods, you are probably going to have to > plan to monitor the server's RAM usage and reboot as it gets close to > the limit. > > If you are confident either that your application does not need the > alias feature (your SQL queries all spell the column names using the > "canonical" spelling for your SQL server), or that you can modify them > to do so, you might try applying the attached patch, which removes the > aliase feature. I should note that I never use the stock results class (or SQL methods) any longer: instead, I use the 'sqladapters' product we wrote when we first discovered the leak: http://agendaless.com/Members/tseaver/software/sqladapters/sqladapters-1.0/ Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 tsea...@palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1BmyoACgkQ+gerLs4ltQ7JpQCgw76+ltS33nnUoDJQepGAWW2c hkMAoNn0PsLtLY1Fp91NxZjbvnv6kbCW =DWNc -----END PGP SIGNATURE----- _______________________________________________ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )