hmm, are you guys getting my email? seems that I am having some email problems.
thanks yan Jonathan Leffler wrote: > Yan Zhu wrote: > > > well, I downloaded all the newest dbi and dbd modules, upgraded my perl > > to 5.6, the leaks are still there! :( > > > > John Cuson wrote: > > > > > not to say that your problem can be similarly addressed, but i have a script >that experienced problems with memory leaks when performing several very large >selects against a mysql table. i was able to isolate the problem to the driver, and >worked around it by dropping the relevant code into a loop and playing with the >number of records i retrieved at a time. i think i ultimately let it go with either >100 or 1000 record result sets. it runs at night, and performance is not really an >issue, so i didn't get deeply into tuning it. > > > > > > john cuson > > > ([EMAIL PROTECTED], [EMAIL PROTECTED]) > > > > > > The world is full of obvious things which nobody by any chance ever observes. > > > > > > Sir Arthur Conan Doyle > > > > > > >>> Yan Zhu <[EMAIL PROTECTED]> 03/28/02 02:13PM >>> > > > > > > This has been brought up before. I am using perl dbi for informix and > > > it leaks out 2 gig of memory after running for several hours! > > > > > > which dbi version fix the dreaded memory leaks? > > Dear Yan Zhu, > > Which memory leak are you running into? I know of one, normally triggered by >preparing a statement and never executing it. Spending two hours doing prepares >without executing sounds implausible, so you probably have a new one I've not heard >about before. So, please can you reduce your example to a test case that reproduces. > There is even a test harness function in the DBD::Informix:TestHarness module for >showing whether there is a memory leak or not. And there are copious instruction on >how to report problems -- your original > message doesn't include the information that's needed. > > If you have version 1.00.PC2, then you are almost out of luck. I do have a couple >of unofficially released later versions, one of which has a fix to the memory leak I >alluded to above. But, without any reproduction information at all, it is kinda hard >to help. > > Key information would be versions of: > Perl > DBI > DBD::Informix > ESQL/C > IDS > It would be helpful to include platform and o/s version. Please read the README >file and use the BugReport script. > > -- > Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) > Guardian of DBD::Informix 1.00.PC2 -- see http://dbi.perl.org/ > #include <disclaimer.h>