#3937 Make individual ticket pages faster - NEEDS ENSURE_INDEX

v1.0.0
closed
Tim Van Steenburgh
performance (126) sf-4 (350)
General
Dave Brondsema
2015-08-20
2012-03-22
Dave Brondsema
No

Profile and fix.

Upgrading to the latest ming should give us some good ming improvements out of the box.

Discussion

  • Dave Brondsema

    Dave Brondsema - 2012-03-22 
    15:03:09,423 INFO  [stats] Stats: /p/allura/tickets/2474/: markdown=54ms ming=3058ms mongo=3948ms render=6307ms template=0ms total=6471ms
15:05:49,715 INFO  [stats] Stats: /p/allura/tickets/2735/: markdown=34ms ming=2479ms mongo=2715ms render=4941ms template=0ms total=5175ms
15:10:49,947 INFO  [stats] Stats: /p/allura/tickets/2034/: markdown=78ms ming=2336ms mongo=5474ms render=7666ms template=0ms total=7907ms
     

  • Dave Brondsema

    Dave Brondsema - 2012-03-26
    • labels: --> performance
     

  • Dave Brondsema

    Dave Brondsema - 2012-03-26

    After the ming upgrade:

    18:00:53,342 INFO  [stats] Stats: /p/allura/tickets/3875/: markdown=13ms ming=2179ms mongo=981ms render=2806ms template=0ms total=3047ms
18:01:00,657 INFO  [stats] Stats: /p/allura/tickets/3920/: markdown=20ms ming=2573ms mongo=1504ms render=3281ms template=0ms total=3512ms
18:06:52,184 INFO  [stats] Stats: /p/allura/tickets/3795/: markdown=68ms ming=2808ms mongo=4633ms render=6508ms template=0ms total=6862ms
     

  • Mark Ramm - 2012-04-02
    • milestone: forge-apr-06 --> forge-apr-20
     

  • Dave Brondsema

    Dave Brondsema - 2012-04-09
    • assigned_to: Tim Van Steenburgh --> nobody
    • size: --> 4
     

  • Tim Van Steenburgh - 2012-04-16
    • status: open --> in-progress
    • assigned_to: Tim Van Steenburgh
     

  • Tim Van Steenburgh - 2012-04-17

    forge:tv/3937

    Code review only. Label queries were taking ~3s due to missing index. Added new index on Artifact.labels. I ran ensure_index and verified that the index is created on inheriting collections.

    • status: code-review --> closed
     

  • Tim Van Steenburgh - 2012-04-17
    • summary: Make individual ticket pages faster --> Make individual ticket pages faster - NEEDS ENSURE_INDEX
    • status: in-progress --> code-review
    • qa: ⸘Dave Brondsema‽
     

  • Tim Van Steenburgh - 2012-04-19
    • status: closed --> open
     

  • Tim Van Steenburgh - 2012-04-19

    Query changed after this index was created. Need to change it to (labels, app_config_id).

     

  • Tim Van Steenburgh - 2012-04-19
    • status: open --> closed
     

Log in to post a comment.