Hey All,
I’m using ActiveRecord w/the sqlite3 adapter and finding it slow for
my use. After reading _whytheluckystiff’s
http://whytheluckystiff.net/articles/aQuickGuideToSQLite.html I
wondered if it’s possible to configure the default_synchronous option
on an ActiveRecord connection. Does anyone know if this is possible?
I tried
ActiveRecord::Base.establish_connection(
:adapter => “sqlite3”,
:database => STORE + “test.db”,
:options => “PRAGMA default_synchronous=OFF”
)
and
ActiveRecord::Base.establish_connection(
:adapter => “sqlite3”,
:database => STORE + “test.db”,
:default_synchronous => “OFF”
)
and didn’t get any errors, but I’m not seeing any speed increase
either (also, it looks like I can pass any gobbledygook in as :options
and not get any errors). So I’m hoping I’m doing it wrong and someone
here can tell me how to do it right.
Many thanks!
-Roy