Jeffrey L. Taylor wrote: > Quoting adedip <[email protected]>: >> of minutes..yesterday I've kept loading..it reached the 56K >> articles..but now is stuck again... >> >> In testing this on a different machine that I use from remote.. any >> clue? >> >> (the solr server is perfectly reachable...) >> > I have a development system with over 5 million rows in one table. The > string > field is typically 5-50 characters, the rest is a half dozen integers of > different sizes. The production system has over 6 million rows. > > That said, ActiveRecord is convenient and memory greedy. For that afore > mentioned table, I just use straight SQL (inserts and selects can run to > thousands of rows).
Have you tried ar-extensions? This should let you do bulk queries properly. > For the other tables, I continue to use > ActiveRecord. > > HTH, > Jeffrey Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
