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.
On Mar 18, 3:15 am, Sathish Kumar <ruby-forum-incom...@andreas-s.net>
wrote:> 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
> --
> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---