Query optimization Rails MongoDB

Hi i have a Query like this to Download details as CSV and using MongoDb, Mongoid

users.all.each do |user|

csv << [user.id.to_s,

      user.profile.id,

      user.profile.status,

      user.profile.username,

      render_time(user.created_at),

      render_time(user.updated_at),

      render_time(user.checked_out_at),

      render_time(user.checked_in_at),

      user.result,

      user.state,

      user.language,

      user.content,

      user.score.to_s,

      users_url(user)]

end

But For instance, this is the tail of my local log when I export to csv 20000 users It Dies and i got a Empty csv file ,

Is there any recommended ways/suggestion to resolve this issue ?

Thanks in advance :slight_smile:

You have not shown us the log.

Colin

MONGODB database['users'].find({:_id=>BSON::ObjectId('4e97324912959c3296067674576500225')})
Rendered users/index.csv.rcsv (103390.8ms)
Completed 200 OK in 104969ms (Views: 103402.9ms)

MONGODB database['users'].find({:_id=>BSON::ObjectId('4e97324912959c3296067674576500225')}) Rendered users/index.csv.rcsv (103390.8ms) Completed 200 OK in 104969ms (Views: 103402.9ms)

Please don't top post, it makes it difficult to follow the thread, insert your reply at the appropriate points in the previous message. Thanks.

You said that the application died, what makes you say that it died?

Have you tried using ruby-debug to break into your code and inspect the data to see where it is going wrong? See the Rails Guide on debugging to find how to do that.

Colin