Gary -- it's more likely in DBD::ODBC than DBI. If you can create a self-contained sample, it would be greatly appreciated and looked at faster :)
You didn't indicate if the loop is a set of inserts, queries, etc. Does it have longs? What's the LongReadLen value? If you can, include a drop table and create table statement at the top, insert test data, then run through something similar to your loop that's leaking. Tim -- if you have suggestions as to how to approach this with Perl, I'd be very appreciative! Regards, Jeff > > Tim; > > I'm using DBI v1.30 and DBD-ODBC v0.43. My database(SQL2000) app > is invoked about 40,000 times over the course of about 2 days to > generate test scripts for some automated test equipment. I've > been noticing the memory usage creeping up over the course of the > runs (up to � Meg per loop at times). I have seen a report on the > developers mail list regarding this problem in recent versions. > Have you done any tests to check for leaks, or have you had any > reports of leaks? Perhaps there is some peculiarity of SQL2000, > that requires explicit releasing of handles or buffer space? > > Any help would be appreciated. > > Regards; > Gary >
