Tuleap 16 est là ! Assistez à l'événement virtuel le 17 octobre à 10h30. Inscrivez-vous ici !

    •  
      request #9981 Assigned/submitted Tracker widget is slow and unaccurate
    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
    Empty
    References

    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

     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

    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

    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

    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
    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
    • 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)