Skip to content

Instantly share code, notes, and snippets.

@jasonmimick

jasonmimick/device searching stsats

Created September 12, 2016 16:22
Show Gist options
  • Save jasonmimick/09493c79217c4414a1c87fefa253b3c6 to your computer and use it in GitHub Desktop.
Save jasonmimick/09493c79217c4414a1c87fefa253b3c6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
device searching stsats
rs:PRIMARY> db.device_suffixes.find({"suffixes":/^ISCO/}).count()
39303
rs:PRIMARY> db.device_suffixes.find({"suffixes":/^ISCO/}).explain(1).executionStats.executionTimeMillis
52
rs:PRIMARY> db.Device_Terms.find({"term":/.*isco.*/i})
{ "_id" : 67903, "term" : "cisco" }
{ "_id" : 67902, "term" : "cisco3650-48pd-e" }
{ "_id" : 67901, "term" : "cisco7604" }
{ "_id" : 67900, "term" : "cisco7606" }
{ "_id" : 67899, "term" : "cisco7609" }
{ "_id" : 67898, "term" : "cisco7609-s" }
{ "_id" : 67897, "term" : "cisco7613" }
{ "_id" : 67896, "term" : "ciscoasr9001" }
rs:PRIMARY> db.Device_Terms.find({"term":/.*isco.*/i}).explain(1).executionStats.executionTimeMillis
87
rs:PRIMARY> db.Device.find( { "$text" : { "$search" : "cisco" } }).count()
39303
rs:PRIMARY> db.Device.find( { "$text" : { "$search" : "cisco" } }).explain(1).executionStats.executionTimeMillis
96
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment