rtanglao/getNumberOfGetSatisfactionTopicsUnified2011Jan1-2011May27.md

Created May 31, 2011 04:27

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rtanglao/999859.js"></script>
Save rtanglao/999859 to your computer and use it in GitHub Desktop.

Download ZIP

getNumberOfGetSatisfactionTopics w/"unified" between 2011 1 Jan to 2011 27 May

Raw

getNumberOfGetSatisfactionTopicsUnified2011Jan1-2011May27.md

Answer: 85 (bug?) topics created with the word "unified" from Jan 1, 2011 to May 27, 2011

> var start2 = new Date(Date.UTC(2011,0,1));
> var end2 = new Date(Date.UTC(2011,4,27)); 
> db.topics.find({"created_at": {$gte: start2, $lt: end2},
"$where":"this.fulltext.indexOf(\"unified\") != -1"}).count();
85

Author

rtanglao commented May 31, 2011

see identical query for an earlier period (August 1, 2010 to January 1, 2011):
https://gist.github.com/gists/999846/edit

Author

rtanglao commented Jun 5, 2011

with database fixed with 40000 instead of 23000 topics:

> var start2 = new Date(Date.UTC(2011,0,1));
> var end2 = new Date(Date.UTC(2011,4,27)); 
> db.topics.find({"created_at": {$gte: start2, $lt: end2},
... "$where":"this.fulltext.indexOf(\"unified\") != -1"}).count();
110