SQL QUERY TIEMOUT Using Ruby on Rails

begin
Timeout::timeout(5) {
@db.query(select * from books")
}
rescue Timeout::Error
puts “Too slow, forget about it.”
end

For instance, In above statment, @db.query will take 10 seconds to
complete.

But,

I would like to kill that query after 5 seconds.

how to kill the running @db.query in rescue statment.? With in 5
seconds whatever records fetched from db, How can i get those results?

Any ideas??..

2011/11/22 Sathiyaraj G. [email protected]:

I would like to kill that query after 5 seconds.

how to kill the running @db.query in rescue statment.? With in 5
seconds whatever records fetched from db, How can i get those results?

As far as I understand the mechanisms of a RDBMS thats an “all or
nothing” strategy. You could kill the task after 5 secs, but wouldn’t
get anything or wait until finished and have it all.

Another way would be to fetch in bunches of about 1000 Datasets and
stop the time, and when the 5 secs are gone, you can use all the
“bunches” you queried so far

HTH
Norbert

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs