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

    Empty
    Trackers
    11.6
    Empty
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Closed
    2019-10-23
    Attachments
    Empty
    References

    Follow-ups

    • User avatar

      gerrit #16621 integrated into Tuleap 11.7.99.89

    • User avatar
      • Status changed from Under implementation to Closed
      • Connected artifacts
      • Close date set to 2019-10-23
    • User avatar
      gerrit #16494 integrated into Tuleap 11.7.99.26
    • User avatar
      gerrit #16512 integrated into Tuleap 11.7.99.20
    • User avatar
      • Original Submission