From: "Simon Kröger" <SimonKroeger@...>
Date: 2006-03-26T19:48:34+09:00
Subject: Re: Best Database For Ruby

Reid Thompson:

>> Runs in 12-13 seconds -- entirely possible that the other box( p4,
>> 2+ghz, 1GB ram, native ruby ) could drop it down under 10 seconds( or
>> even this box, if I took cygwin out of the equation ).
>>
>> db =Og.setup(og_psql)
>> t1= Time.now
>> db.store.start
>>
>> 1.upto(10000)  { |i|
>> c = Comment.new
>> c.title = 'Hello'
>> c.body = 'World'
>> c.create_time = Time.now
>> c.author = 'tml'
>> c.save
>> }
>>
>> db.store.commit
>> puts  Time.now - t1
>>
>>
>>
> Upated athlon system to PostgreSQL 8.1.3
> 8.78-9.2 seconds...

As Ara said: "it's madness not to use sqlite" if you don't need the
networking capabilities of MySQL or whatever.

change DB to sqlite3:

-----------------------------------------------------------
require 'sqlite3'

File.delete("test.db") if File.exists?("test.db")
db = SQLite3::Database.new("test.db")
t1= Time.now

db.execute("CREATE TABLE comments (title, body, create_time, author)")

db.transaction do
  1.upto(10000)  do
    db.execute("insert into comments values ('Hello', 'World', ?, 'tml'
)", Time.now)
  end
end

puts  Time.now - t1
------------------------------------------------------------
1.5 seconds

(Pentium M, 2.13GHz, 1GB RAM)

cheers

Simon