#7065 Slow post queries happening on invalid URLs

v1.1.0
closed
General
Cory Johns
2015-08-20
2014-01-16
No

On a URL like /p/foobar/tickets/_discuss/thread/092b4865/3547/blah/blah/bogus the response is quite slow, e.g. stats.log: "timings": {"total": 466534, "mongo": 466506, "ming": 466516}}}

This is due to an unindexed mongo query: query project-data.post query: { slug: "3547/blah/blah/bogus" } ntoreturn:0 ntoskip:0 nscanned:19604 keyUpdates:0 numYields: 503 locks(micros) r:37235 nreturned:0 reslen:20 5253ms

Discussion

  • Dave Brondsema

    Dave Brondsema - 2014-01-16
    • status: in-progress --> code-review
     
  • Dave Brondsema

    Dave Brondsema - 2014-01-16

    db/7065

     
  • Cory Johns

    Cory Johns - 2014-01-16
    • QA: Cory Johns
     
  • Cory Johns

    Cory Johns - 2014-01-16
    • status: code-review --> closed