From: Robert Klemme Date: 2013-02-01T16:50:53+09:00 Subject: Re: Does Ruby has any default database with it? On Fri, Feb 1, 2013 at 7:50 AM, Arup Rakshit wrote: > Carlo E. Prelz wrote in post #1094684: >> Subject: Re: Does Ruby has any default database with it? >> Date: Fri 01 Feb 13 12:30:50PM +0900 >> >> Quoting Arup Rakshit (lists@ruby-forum.com): >> >>> My concern is - Does "Sqllite3" capable of storing 30000 rows in each >>> table? I will use it in my internal projects. >> >> If you want to adopt a database engine, you'd better read some of the > > @Carlo : > > > Thank you very much! That's the information I was looking from you like > experienced people. If it's just 30,000 items then Marshal or PStore might do as well. If the whole data set easily fits into memory that would probably be the easiest choice. Sample: $ time ruby -e 'h={};30_000.times {|i| h[i]=10.times.map(&:to_s)};t=Time.now;File.open("x","wb"){|io|Marshal.dump(h, io)};puts(Time.now-t)' 0.3430196 real 0m0.597s user 0m0.452s sys 0m0.124s Kind regards robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/