# Memory leak problem

**URL:** <https://www.ruby-forum.com/t/memory-leak-problem/226028>\
**Category:** Rails\
**Created:** [October 8, 2008, 6:40pm UTC](https://www.ruby-forum.com/t/memory-leak-problem/226028 "2008-10-08T18:40:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![elioncho](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ed8c4c/32.png) [@elioncho](https://www.ruby-forum.com/u/elioncho)\
**Post date:** [October 8, 2008, 6:40pm UTC](https://www.ruby-forum.com/t/memory-leak-problem/226028/1 "2008-10-08T18:40:01Z")

</div>

I have a txt file with some data that i need to import to de database.  
I’m using ruby to import those data but i have a major problem, when i  
've  
a large amount of data i run out of memory.

File.open("#{RAILS\_ROOT}/public/files/Neighborsville.TXT").each() do  
|line|  
@stringArray = line.split("|")  
@i += 1  
puts @i  
@pid = @stringArray[0]  
@chain\_id = @stringArray[1]  
@business = Business.find\_by\_pid\_and\_chain\_id(@pid,@chain\_id);  
#Check PID + CHAIN\_ID  
@business.pid = @stringArray[0]  
@business.chain\_id = @stringArray[1]  
@business.cityname = @stringArray[17]  
@business.state = @stringArray[18]  
@business.business =  
Business.find\_by\_pid\_and\_chain\_id(@pid,@chain\_id);  
@business.city = City.new  
@business.business\_category = get\_category\_id(@stringArray[40])  
@business.address = @stringArray[8] +" “+ @stringArray[9] +”  
“+ @stringArray[10]+” “+ @stringArray[11] +” “+@stringArray[12]+”  
“+@stringArray[13]+” "+@stringArray[14]  
if @chain\_id == nil  
@chain\_id = “”  
end  
business.save  
end  
end

I belive that ruby use in every cycle of the do new blocks of memories  
por my instances  
of Business. Can someone help me please?

Thanks,

Elioncho

---

<div class="post-metadata">

**Author:** ![elioncho](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ed8c4c/32.png) [@elioncho](https://www.ruby-forum.com/u/elioncho)\
**Post date:** [October 8, 2008, 7:10pm UTC](https://www.ruby-forum.com/t/memory-leak-problem/226028/2 "2008-10-08T19:10:33Z")

</div>

Probably not related, but should business.save at the end there be  
@business.save?
