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 #8696 Improve site statistics generation time
    Actions
    Infos
    #8696
    Sandra Echinard (sechinard)
    2016-01-15 17:01
    2015-12-11 11:06
    8817
    Details
    Improve site statistics generation time
    Empty
    Other
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2016-01-05
    Attachments
    Artifact links
    Empty
    Empty
    References
    Referencing request #8696

    Artifact Tracker v5

    rel #8596 8.10
    rel #8700 8.11

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/81/4881/3' of ssh://gerrit.tuleap.net:29418/tuleap into tuleap-stable-master 7d762cc499
    User avatar Manuel Vacelet (vaceletm) , 2016-01-04 17:33
    request #8696: Optimize transformation of statistics export to CSV 56f9c4e0fd
    User avatar Thomas Gerbet (tgerbet) , 2015-12-29 15:17
    Merge commit 'gerrit #4878' into stable/master da6eeaaff0
    User avatar Thomas Gerbet (tgerbet) , 2016-01-15 16:55
    request #8696: Service usage stats meet php limit 29afbc7f34
    User avatar Sandra Echinard (sechinard) , 2015-12-11 14:36
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2016-01-15 17:01
    Work around site statistics generation time integrated into Tuleap 8.10.99.12.
    User avatar
    Sandra Echinard (sechinard)2016-01-06 11:29
    last edited by: Sandra Echinard (sechinard) 2016-01-06 13:34
    Integrated in 8.10
    https://gerrit.tuleap.net/#/c/4881/
    Details:
    Optimize transformation of statistics export to CSV


    Also add indexes to speed up MySQL queries.

    Given the following code snippet:
    $data_line = array('Data1,', 'Data 2', 'Data 3', 'Data 4', 'Data5');
    $statistics_formatter = new Statistics_Formatter('', '', ',');
    for($i = 0; $i < 20000; $i++) {
    $statistics_formatter->addHeader('Title');
    $statistics_formatter->addLine($data_line);
    $statistics_formatter->addEmptyLine();
    $statistics_formatter->addLine($data_line);
    }
    $statistics_formatter->getCsvContent();

    I get these results on my dev instances:
    Before optimization: 6.04s
    After optimization: 250ms
    Both implementation have a similar memory cost.