Hi, Once, you have finish your fetch you'll need to free memory using : $sth->finish();
It'll be better than nothing. Moreover if your computer came down and frozen you have serious problem, if i were you i'll shop some more RAM... phinney wrote: > Hello all... > > I have a DBI call that returns a long list of names (10,000). I am > using fetchall_arrayref. The call seems to take up 40MB of memory. Is > this normal? Am I doing something wrong? Is there any special way to > free up this memory. > > -- =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-= Nicolas JOURDEN #41100039 - +33 0681940905 http://ddx.ovh.org/ - Programmeur Perl, CGI, Sql, XML/HTML. http://www.wireless-fr.org/ - Liberons les reseaux ! =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=