Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #9981 Assigned/submitted Tracker widget is slow and unaccurate
    Actions
    Infos
    #9981
    Manuel Vacelet (vaceletm)
    2017-08-11 16:28
    2017-02-23 15:04
    10274
    Details
    Assigned/submitted Tracker widget is slow and unaccurate

    "My artifacts" widget has severe performance hurdle. It's reported to take more than 40s for some users and according to slow queries log, it can take up to 200s!

    While inspecting the query, we found that, in addition to performance issue there is a functional issue, the query is overfiltering "Assigned to" artifacts and report less artifacts than there actually are.

    For the 40s user, we got better results (still 23s...) but the number of returned results is way too high (~2000 artifacts returned).

    If obviously not usable to have 2000 artifacts on "My personal page", even if we manage to fetch the data faster. So the question is: how this widget is actually used or could be more useful by displaying less information ?

    Other
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Patricia Carrasco (pcar), Rez Sharghi (rcharghi)
    Stage
    Empty
    Verified
    Empty
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #10042 Tuleap Releases 9.7 Delivered 2017-04-27 15:37 Manuel Vacelet (vaceletm)
    rel #10478 Tuleap Releases 9.11 Delivered 2017-08-18 11:11 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #9981

    Git commit

    tuleap/tuleap/stable

    Merge 'gerrit #8101' into stable/master 7110dcbf39
    User avatar Thomas Gerbet (tgerbet) , 2017-04-07 15:00
    request #9981 Assigned/submitted Tracker widget is slow and unaccurate c3400741f3
    User avatar Manuel Vacelet (vaceletm) , 2017-04-06 15:11
    SQL query to retrieve assigned or created artifacts by a user is slow and inaccurate d720f74859
    User avatar Thomas Gerbet (tgerbet) , 2017-08-10 14:47
    SQL query to retrieve assigned or created artifacts by a user might returned duplicated artifacts 3a2df75891
    User avatar Thomas Gerbet (tgerbet) , 2017-08-10 17:47
    Cache the information of a user being tracker administrator 2d0716a907
    User avatar Thomas Gerbet (tgerbet) , 2017-08-11 12:03
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2017-08-11 16:28
    Ok so the last 3 contributions have:
    * fixed the behavior of the widget when retrieving the artifacts assigned to and submitted by a user
    * improved the performance when retrieving the artifacts assigned to or submitted by a user. Retrieval time is now similar than when retrieving only the submitted by or assigned to artifacts.
    * in all cases the number of SQL queries that are made to retrieve artifacts has been reduced.

    With the data sets I got, the response times are now acceptable.


    The question of how to make the widgets more usable when you have a lot of artifact has not been resolved tough, as such I don't the request yet.
    User avatar
    Benjamin Dauton (bdauton_enalean)2017-03-08 14:27

     If we put project and trackers filter in the configuration, you'll need to reconfigure the widget to show other project/trackers' artifacts.

    [I guess by default nothing will be displayed in the widget until the user adds the widget to the Personal Page and then must configure it to show the Assigned/Submitted tracker(s) for selected project(s).  Should there be a limit on the # of project/trackers you can select (for performance reasons)???]

    Yes this is why I thought but if the user want to see other projects or trackers, he would have to go again into the widget configuration, select projects/trackers and save changes.

    I propose to start with this solution to resolve performance issue and we'll see later if the user need to change these filters often.

    User avatar
    Patricia Carrasco (pcar)2017-03-07 15:52

    This widget can't be added twice

    [Agree]

     If we put project and trackers filter in the configuration, you'll need to reconfigure the widget to show other project/trackers' artifacts.

    [I guess by default nothing will be displayed in the widget until the user adds the widget to the Personal Page and then must configure it to show the Assigned/Submitted tracker(s) for selected project(s).  Should there be a limit on the # of project/trackers you can select (for performance reasons)???]

    Are you ok with that or do you prefer to play with these filters accessible "on the fly" (without going into the widget configuration)? If you prefer the "on the fly" mode, project and trackers filters in the widget configuration could be only the default filters values and any changes done in the widget "front view" won't be saved

    [No sure what is meant by "on the fly".  Where would it be done from?]

    User avatar
    Benjamin Dauton (bdauton_enalean)2017-03-06 15:33

    Hi all,

    This widget can't be added twice. If we put project and trackers filter in the configuration, you'll need to reconfigure the widget to show other project/trackers' artifacts. Are you ok with that or do you prefer to play with these filters accessible "on the fly" (without going into the widget configuration)?

    If you prefer the "on the fly" mode, project and trackers filters in the widget configuration could be only the default filters values and any changes done in the widget "front view" won't be saved.

    What do you think about that?

    User avatar
    Manuel Vacelet (vaceletm)2017-02-27 14:59

    I think the user should be able to refine the filter. Currently the widget displays all Submitted/Assigned artifacts for the user. Maybe allow the user to select the tracker(s) for a project would be a good starting point.

    Ok, how would you like to configure that ?

    In widget being able to select the projects or trackers you are interested in would be enough ?

    User avatar
    Patricia Carrasco (pcar)2017-02-24 17:31
    I think the user should be able to refine the filter. Currently the widget displays all Submitted/Assigned artifacts for the user. Maybe allow the user to select the tracker(s) for a project would be a good starting point.
    User avatar
    Manuel Vacelet (vaceletm)2017-02-24 09:16
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    • Status changed from New to Verified
    • CC list set to Patricia Carrasco (pcar), Rez Sharghi (rcharghi)