EDN Admin
Well-known member
This is from my blog about a speed comparison between Windward and XSL-FO - http://blogs.windwardreports.com/davidt/2010/11/tens-of-pages-per-second-not-seconds-per-page.html
(Tens of) Pages per Second, not Seconds per Page
<blockquote>
I was recently talking to a developer who after great effort had constructed a monthly statement generating system based around XSL-FO that would produce 10 pages/second. He had put a lot of effort into fine-tuning the XSL-FO as well as writing an engine
that created enough threads to keep all 4 processors pegged. He was justifiably proud that they were running at this rate.
That got me wondering what Windward could do. So I created a somewhat simple statement and pointed it at the AdventureWorks database that comes with Sql Server. You can download the template (docx) and generated report (pdf) at
<span> http://blogs.windwardreports.com/files/sample_monthly_bill.zip Sample_Monthly_Bill . I set it to just generate statements for the first 1,000 customers in the database.
So how did we do? It generated 1,080 pages in 2:33. Thats 7.06 pages/second. But you wont get a number like this â youll get one much better. I ran this on my desktop system which is a Dell OptiPlex with a dual core 3GHz processor â but I
ran the engine single threaded and our reporting system is I/O bound so splitting it into 4 threads (we find you can go up to 2X the number of cores and get dramatic increases) on my system would probably
take us up to about 20 pages/second . (It was also probably slower because I had iTunes playing as well as several other apps open, each using part of the CPU.)
Put this on a single http://www.oracle.com/us/products/database/database-machine/index.html
8-way SnOracle box and we probably go from tens of pages/second to hundreds of pages/second .
And how long did it take me to create this template? Under 5 minutes. Definitely a lot less time than hand-crafting XSL-FO.
</blockquote>
So is this as fast as XSL-FO? I know thats a hard thing to ask generally, but is is against a specific example.
??? - thanks - dave <hr class="sig Very funny video - http://blogs.windwardreports.com/davidt/2010/02/reporting-as-a-metaphor.html
Whats your Metaphor?
View the full article
(Tens of) Pages per Second, not Seconds per Page
<blockquote>
I was recently talking to a developer who after great effort had constructed a monthly statement generating system based around XSL-FO that would produce 10 pages/second. He had put a lot of effort into fine-tuning the XSL-FO as well as writing an engine
that created enough threads to keep all 4 processors pegged. He was justifiably proud that they were running at this rate.
That got me wondering what Windward could do. So I created a somewhat simple statement and pointed it at the AdventureWorks database that comes with Sql Server. You can download the template (docx) and generated report (pdf) at
<span> http://blogs.windwardreports.com/files/sample_monthly_bill.zip Sample_Monthly_Bill . I set it to just generate statements for the first 1,000 customers in the database.
So how did we do? It generated 1,080 pages in 2:33. Thats 7.06 pages/second. But you wont get a number like this â youll get one much better. I ran this on my desktop system which is a Dell OptiPlex with a dual core 3GHz processor â but I
ran the engine single threaded and our reporting system is I/O bound so splitting it into 4 threads (we find you can go up to 2X the number of cores and get dramatic increases) on my system would probably
take us up to about 20 pages/second . (It was also probably slower because I had iTunes playing as well as several other apps open, each using part of the CPU.)
Put this on a single http://www.oracle.com/us/products/database/database-machine/index.html
8-way SnOracle box and we probably go from tens of pages/second to hundreds of pages/second .
And how long did it take me to create this template? Under 5 minutes. Definitely a lot less time than hand-crafting XSL-FO.
</blockquote>
So is this as fast as XSL-FO? I know thats a hard thing to ask generally, but is is against a specific example.
??? - thanks - dave <hr class="sig Very funny video - http://blogs.windwardreports.com/davidt/2010/02/reporting-as-a-metaphor.html
Whats your Metaphor?
View the full article