Query optimization Rails MongoDB

[Rajeev Kannav Sharma]

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 :)

[Colin Law]

On 22 November 2011 09:29, Rajeev Kannav Sharma

You have not shown us the log.

Colin

[rajeevsharma86]

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

--
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 rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
Rajeev Kannav Sharma

[Colin Law]

On 22 November 2011 10:41, rajeevsharma86 <rajeevs...@gmail.com> wrote:
> 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

--
gplus.to/clanlaw