Skip to content

Instantly share code, notes, and snippets.

@rtanglao

rtanglao/howManyTopicsWithUnResponsive.sh

Created May 31, 2011 00:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rtanglao/999661 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rtanglao/999661 to your computer and use it in GitHub Desktop.
Download ZIP
how many topics have the word unresponsive in them since I started July 21, 2009?
Raw
howManyTopicsWithUnResponsive.sh
> db.topics.find({"$where":"this.fulltext.indexOf(\"unresponsive\") != -1"}).count()
95
> db.topics.find({"$where":"this.fulltext_with_tags.indexOf(\"unresponsive\") != -1"}).count()
65
# This 65 sounds like a bug in my Mongo Database i.e. a bug in :
# https://github.com/rtanglao/momogs/blob/master/mongoSlurpGS.rb
@rtanglao
Copy link
Author

rtanglao commented Jun 5, 2011

updated with 40000 topics instead of 23000:

db.topics.find({"$where":"this.fulltext.indexOf(\"unresponsive\") != -1"}).count() 
105

> db.topics.find({"$where":"this.fulltext_with_tags.indexOf(\"unresponsive\") != -1"}).count()
115

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment