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

    Follow-ups

    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