You are here

Improve my MongoDB query to get the number of Thunderbird support topics created or replied to within a given time period please

Submitted by Roland on Wed, 2011-05-11 14:27

I have a mongodb  database created by my mongoUpdateSlurpGS.rb Ruby script with Thunderbird Get Satisfaction support topics from July 20, 2009 until the present (i.e. roughly 40000 topics) and I would like to know for a given time period how many support topics were created or modified. To calculate this, I wrote a second ruby script called alltopicsCreatedOrUpdated.rb (and the code is embedded below). My question is: is there really a need for a ruby script here.? Could the nested for "each" loop in alltopicsCreatedOrUpdated.rb  be replaced by a couple of mongodb queries using the mongodb command line interface?

Comments

The clarity in your post is simply great Must confess that you present powerful steps on this blog, MrqePromoCode You definitely know what you were talking about and Your intelligence on the post could be giving us new knowledge.Pretty great post. InkPromoCode I simply stumbled upon your  weblog and wanted to say that I have really loved browsing your blog posts.Simply wish to say your article is as astonishing. The clarity in your post is simply great and i could asume you are an expert on this subject. AutoPartsPromoCode Well with your permission let me to grab your RSS feed to keep updated with forthcoming post.

Add new comment