Rodney Broom wrote: > From: Eric <[EMAIL PROTECTED]> > > >>What about in the case of a big query result? > > > I may have come into this thread a bit late, but can't you just undefine the storage >when you're done with it? > > $data = $sth->fetchall_arrayref; > #... do some stuff; > $data = undef;
That will release the memory from that lexical so that perl can use it elsewhere, but it will not release it back to the OS. It's a good idea though, in any situation where you occasionally load large chunks of data into a scalar. (Not a good idea if you load large chunks of data into that scalar on most requests.) - Perrin