Edgewall Software

Changes between Initial Version and Version 1 of Ticket #10635


Ignore:
Timestamp:
Mar 21, 2012, 9:44:31 AM (7 years ago)
Author:
Christian Boos
Comment:
>>> size_html, time_html = 1762922.0, 9.574
>>> size_text, time_text = 164781.0, 0.691
>>> size_html / size_text, time_html / time_text
(10.698575685303524, 13.855282199710565)

Pretty much the same ratio, and the remaining difference can certainly be explained by the extra complexity of Genshi' html templates vs. text templates.

Of course, one wouldn't expect that the major part of the processing time for such queries is devoted to the rendering, but that's a well known issue we have with our beloved Genshi templating engine ;-)

In the meantime, you should try to use a recent version of Genshi (at least 0.6; as you didn't say which Trac version you were using, you might be using a Genshi 0.5 version).

See also TracDev/Performance#Genshi.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #10635

    • Property Keywords performance genshi added
    • Property Milestoneunscheduled
  • Ticket #10635 – Description

    initial v1  
    44I suspect its the same issue as the symptoms look the same. But iam just guessing here
    55
    6 heres an example:
     6here's an example:
    77
    88time wget 'http://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'
     
    1111Connecting to trac.edgewall.org|176.9.102.26|:80... connected.
    1212HTTP request sent, awaiting response... 200 Ok
    13 Length: 1762922 (1.7M) [text/html]
     13**Length: 1762922 (1.7M) [text/html]**
    1414Saving to: “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”
    1515
    16162012-03-21 00:37:24 (1.05 MB/s) - “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” saved [1762922/1762922]
    1717
    18 real    0m9.574s
     18**real  0m9.574s**
    1919user    0m0.008s
    2020sys     0m0.068s
     
    2525Connecting to trac.edgewall.org|176.9.102.26|:80... connected.
    2626HTTP request sent, awaiting response... 200 Ok
    27 Length: 164781 (161K) [text/csv]
     27**Length: 164781 (161K) [text/csv]**
    2828Saving to: “query?format=csv&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.1”
    2929
    30302012-03-21 00:38:55 (671 KB/s) - “query?format=csv&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.1” saved [164781/164781]
    3131
    32 real    0m0.691s
     32**real  0m0.691s**
    3333user    0m0.000s
    3434sys     0m0.012s