-----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 tseaver@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-----