[allura:tickets] #6677 User profile's list of projects is slow to build

[Mykola Kharechko <kh...@users.sf.net>]

Hi. I have tried to reproduce the bug. Have created 50+ empty projects. Ping /u/root/profile/ but my numbers much less then yours:

    {"url": "/u/root/profile/", "uptime": 6,
     "call_counts": {"total": 1, "ming": 572, "jinja": 1, "mongo": 505}, "request_category": "profile",
     "timings": {"total": 1275, "ming": 342, "jinja": 991, "mongo": 178}}

can you give more details? I am interested in type of queries to mongo. can you give me mongo profiling information?

    mongo shell> db.setProfilingLevel(0); db.system.profile.drop(); db.createCollection( "system.profile", { capped: true, size:4000000 } ); db.setProfilingLevel(2)
    bash> curl http://localhost:8080/u/root/profile/
    bash> mongodump -d allura -c system.profile


---

** [tickets:#6677] User profile's list of projects is slow to build**

**Status:** in-progress
**Labels:** performance 42cc 
**Created:** Thu Sep 19, 2013 08:20 PM UTC by Dave Brondsema
**Last Updated:** Thu Jan 02, 2014 05:16 PM UTC
**Owner:** nobody

With 54 projects, a ridiculous amount of ming & mongo calls are executed on a profile page:

~~~~
{
    "url": "/u/brondsem/profile/",
    "uptime": 1820,
    "call_counts": {
        "socket_write": 1,
        "jinja": 1,
        "mongo": 30396,
        "total": 1,
        "socket_read": 14,
        "ming": 1102
    },
    "request_category": "profile",
    "timings": {
        "mongo": 2618,
        "ming": 1328,
        "socket_write": 0,
        "socket_read": 93,
        "total": 4528,
        "jinja": 4478
    }
}
~~~~


---

Sent from sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.