Details
-
Bug
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
None
-
OS X
Description
Forgive that I don't know the right project where I should log this issue.
Please review this SO post for history: http://stackoverflow.com/questions/17904881/mongo-mapper-rails-queries-suddenly-taking-100-ms
Right now mongo queries have double again:
MONGODB (265.7ms) creative_development['jobtypes'].find({:merchant_id=>"518b762e89651a0389000013"})
MONGODB (264.9ms) creative_development['jobpriorities'].find({:merchant_id=>"518b762e89651a0389000013"})
MONGODB (264.9ms) creative_development['admins'].find({:usertype=>3, :merchant_id=>"518b762e89651a0389000013"})
MONGODB (264.2ms) creative_development['jobs'].find({:merchant_id=>"518b762e89651a0389000013"}).limit(-1)
MONGODB (265.8ms) creative_development['jobtypes'].find({:merchant_id=>"518b762e89651a0389000013"})
MONGODB (265.1ms) creative_development['jobpriorities'].find({:merchant_id=>"518b762e89651a0389000013"})
I've tried repairDatabase, clean, drop the database and restore data, uninstall mongo, reinstall, new version of mongomapper (gem 'mongo_mapper', '>= 0.13.0.beta1'), I am well and truly out of ideas here.
Please give me some idea why it went from 0.2 ~ 0.5 ms response time locally to over 250ms now...