On 20/04/15 17:54, Mike Martin wrote:
I have the following script (extremley simplified)foreach my $key (sort {$a<=>$b} keys %run){ my $inp; $inp=$dbh->selectall_arrayref("select id, [description] from Kaonix_import_base where idint between ? and ? ",undef,$run{$key}->[0], $run{$key}->[1]) ; addrec($inp); -- sub to run very heavy regexs against the select and insert into another table undef($inp); } The problem is that memory is not being freed against the statement handle on each iteration and eventually the script stalls due lack of memories any ideas?
Hi Mike, What makes you point the finger at the statement handle not being freed? Can you make this happen in a small standalone script and provide schema? What ODBC driver are you using and what versions of DBI, DBD::ODBC and ODBC driver manager? Martin
