Edgewall Software

Changes between Version 12 and Version 15 of Ticket #10635


Ignore:
Timestamp:
Feb 8, 2017, 10:44:43 AM (7 years ago)
Author:
Christian Boos
Comment:

After the upgrade to trunk, best time of 3: 0m3.913s (for 10530 matches and a 1327k query.html).

And 0m2.189s (for a 1405k query.html) after disabling the tracspamfilter.filters.trapfield.* components (the one implementing the ITemplateStreamFilter interface and forcing the backward compatibility Genshi filtering to take place).

$ time curl -o query.html 'https://trac.edgewall.org/query?max=1000&col=id&col=summary&col=status&col=owner&col=type& col=priority&col=milestone&col=component&col=version&col=severity&col=resolution&col=time&col=reporter&col=keywords&col=cc&order=priority'
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 1405k  100 1405k    0     0   712k      0  0:00:01  0:00:01 --:--:--  713k

real    0m2.115s
user    0m0.046s
sys     0m0.031s

In comparison, the time needed to generate the corresponding .csv file is:

$ time curl -o query.csv 'https://trac.edgewall.org/query?format=csv&max=1000&col=id&col=summary&col=status&col=owner&col=type&col=milestone&col=component&col=version&col=severity&col=resolution&col=time&col=reporter&col=keywords&col=cc&order=priority'
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  169k  100  169k    0     0   249k      0 --:--:-- --:--:-- --:--:--  250k

real    0m0.768s
user    0m0.046s
sys     0m0.000s

So it only takes roughly 3 times longer to generate the HTML than it takes to generate the CSV: not bad!

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #10635

    • Property Status newclosed
    • Property Milestone next-major-releasesnext-dev-1.3.x
    • Property Keywords jinja2 added
    • Property Resolutionfixed
  • Ticket #10635 – Release Notes

    v12 v15  
     15 times speed-up when rendering query results, thanks to the migration from Genshi to Jinja2.