Quoting adedip <[email protected]>: > I didn't know how to title this question sorry :P > > I wrote this application using a MySQL DB and Solr Server (updated via > acts_as_solr plugin) > > I need to load tons of documents to test it out, the app is a > newspaper article collection repository that I upload via SGML corpus. > > Now the strange is..that after loading about 30K articles..the app > started to act weird: it does not load anymore or it does after a lot > 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). For the other tables, I continue to use ActiveRecord. HTH, Jeffrey -- 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.

