Another alternative would be to just wrap your long-running query in a
timeout, something like:
require 'timeout'
...
begin
status = Timeout::timeout(60) do
# some long-running action ....
end
rescue Timeout::Error => te
# ....
end
Jeff
On Oct 13, 1:07 pm, JohnB <john.bay...@gmail.com> wrote:
> You've probably already figured it out, but this looks workable:
>
> # See this page for some of the statement-related settings:
> # http://www.postgresql.org/docs/8.3/static/runtime-config-client.html
> def setStatementTimeout milliseconds
> query = "SET statement_timeout = #{milliseconds};"
> ActiveRecord::Base.connection().execute query
> end
>
> On Sep 25, 6:13 am, skar <skar.karthike...@gmail.com> wrote:
>
>
>
> > Hi,
>
> > I've got an activerecord query which takes longer than 100 seconds. I'm
> > using rails 2.2 with postgresql
> > 8.3.http://www.postgresql.org/docs/8.3/static/runtime-config-client.html
> > mentions an option called "statement_timeout" which when set aborts a
> > query which takes longer than x milli seconds.
>
> > How do I pass this option to AR so that it in turn passes this to
> > postgresql?
>
> > cheers,
> > skar.
>
> > --
> > --
> > The life so short, the craft so long to learn.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
