Skip to main content

Tuleap Community Edition development and releases are no longer public. You have until September 30th to download packages and sources in Tuleap project. You can contact the team if you need further assistance.

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 #14048 Slowness at artifact creation
    Infos
    #14048
    Manuel Vacelet (vaceletm)
    2019-11-04 15:41
    2019-10-16 16:08
    15253
    Details
    Slowness at artifact creation

    A couple of slowness were identified on artifact creation:

    • Missing index
    • Missing transaction

    On creation of a test environment on try.tuleap-enterprise.com we went from 78s to 30s (for ~88 artifacts created during XML import)

    On a platform with ~200k artifacts the SQL gains are noticable:

    • Add of index: -50% of SQL time
    • Add of transaction: Another -31% of SQL time

    When we combine both, the creation of a new artifact goes from 330ms to 173ms of wall time (-47%). The SQL part goes from 188ms to 51ms (-73%).

    Measurements where done with default "Bug" tracker.

    The gain will be even better with more artifacts and/or bigger tracker (more fields).

    Trackers
    11.6
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2019-10-23
    Attachments
    Empty
    References
    Display settings

    Follow-ups

    User avatar
    Manuel Vacelet (vaceletm)2019-10-16 17:43
    • 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