Difference between using ActiveRecord and DBI

rubyonrails-core
1

Hello dudes,     I'm sathish i have been working on ruby on rails past 6 to7 months. but i couldn't find a solution for using activerecord or Dbi

    I found the problem in my app that, if we make query to database using active record it'll make connection to database, after finish the database query its not closing the connection defaultly. i found the solution to disconnect and reconnecting the database thru active record like as dbi.

    Still i have the problem in performance. I want to know which is best use to connect the database everytime. i have to read the table which has more than 20 lak records. This connection will happen to retrieve hour(more than 10,000 records /hour)basis records .

    Please let me know which is the best use for connecting the database table which has more than 1 million records.

Regards, sathish kumar

2

Hi Sathish,

This is the wrong mailing list for these kind of usage questions. The list you want is rubyonrails-talk. Please post anything new on that list.

But I'd recommend trying ActiveRecord::Base.connection.select_all and friends and then just benchmark their speed against DBI.