#4358 Remove unnecessary project lookups from app config setup

v1.0.0
closed
Dave Brondsema
performance (126) v2 (44) sf-1 (616)
General
Tim Van Steenburgh
2015-08-20
2012-06-12
Dave Brondsema
No

When building the top nav of a project, each app config entry queries mongo to get the project. That isn't necessary since the project is already known. This can be seen with the timing middleware. Set production.ini stats.sample_rate to 1, and increase the logging:

[logger_timermiddleware]
level = DEBUG
handlers =
qualname = timermiddleware

And then:

tail -F /var/log/allura/allura.log | grep ODMSession.*Project

Discussion

  • Dave Brondsema

    Dave Brondsema - 2012-06-12
    • status: in-progress --> code-review
    • qa: Tim Van Steenburgh
     

  • Dave Brondsema

    Dave Brondsema - 2012-06-12

    allura:db/4358

    • use instructions above to see a reduction in the number of Project queries executed
    • some are still present due to other unrelated queries
     

  • Tim Van Steenburgh - 2012-06-13
    • status: code-review --> closed
     

Log in to post a comment.