| XLS emitter : slow [message #146918] |
Wed, 22 March 2006 04:12 |
Eclipse User |
|
|
|
Originally posted by: rebprotizer_2k3.hotmail.com
I find the XLS emitter very slow for complex reporting.
For a report with 2 bar charts, the export is done after 20 secondes.
For a report with 2 groups. This is the XML Soruce of my report (you can
replace my datasource by the Database of the xample integrated in BIRT,
it's the same) :
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.0.1 Build
<20060222-1204></property>
<property name="units">in</property>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Source de
données" id="4">
<property
name="odaDriverClass">org.postgresql.Driver</property>
<property
name="odaURL">jdbc:postgresql://localhost:5432/postgres</property>
<property name="odaUser">postgres</property>
<encrypted-property
name="odaPassword">VW5pbG9nMjAwNg==</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Jeu de données" id="5">
<property name="dataSource">Source de données</property>
<property name="queryText">select
public.customers.customername,public.orders.orderdate,public .products.productcode,public.products.productname,public.pro ducts.buyprice,public.orderdetails.quantityordered,public.or ders.ordernumber
from public.customers,public.orderdetails,public.orders,public.pr oducts
where public.customers.customernumber = public.orders.customernumber
and public.orders.ordernumber = public.orderdetails.ordernumber
and public.orderdetails.productcode =
public.products.productcode</property>
</oda-data-set>
</data-sets>
<styles>
<style name="CustomerStyle" id="119">
<property name="fontFamily">Arial</property>
<property name="fontWeight">bolder</property>
<property name="color">#0080C0</property>
<property name="borderBottomColor">#0080C0</property>
<property name="borderBottomStyle">solid</property>
</style>
<style name="OrderStyle" id="120">
<property name="fontFamily">Arial</property>
<property name="fontWeight">bold</property>
<property name="fontStyle">italic</property>
<property name="color">#FF8080</property>
<property name="borderBottomColor">#FF8080</property>
<property name="borderBottomStyle">solid</property>
</style>
<style name="OrderNumberStyle" id="137">
<property name="fontFamily">Arial</property>
<property name="fontWeight">bold</property>
</style>
<style name="MoneyStyle" id="23">
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">#,##0.00 </property>
</structure>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2"/>
</page-setup>
<body>
<table id="35">
<property name="height">2.447in</property>
<property name="width">6.02in</property>
<property name="dataSet">Jeu de données</property>
<column id="54">
<property name="width">0.395in</property>
</column>
<column id="55">
<property name="width">0.333in</property>
</column>
<column id="56">
<property name="width">0.375in</property>
</column>
<column id="57">
<property name="width">0.864in</property>
</column>
<column id="58">
<property name="width">3.02in</property>
</column>
<column id="118">
<property name="width">0.354in</property>
</column>
<column id="146">
<property name="width">0.697in</property>
</column>
<group id="84">
<property name="groupName">CustomerGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["customername"]</expression>
<list-property name="sort">
<structure>
<expression
name="key">row["customername"]</expression>
</structure>
</list-property>
<header>
<row id="85">
<cell id="86">
<property name="colSpan">7</property>
<property name="rowSpan">1</property>
<data id="97">
<property
name="style">CustomerStyle</property>
<expression
name="valueExpr">row["customername"]</expression>
</data>
</cell>
</row>
</header>
<footer>
<row id="91">
<cell id="92"/>
<cell id="93"/>
<cell id="94"/>
<cell id="95"/>
<cell id="96"/>
<cell id="116"/>
<cell id="144"/>
</row>
</footer>
</group>
<group id="98">
<property name="groupName">OrderGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["orderdate"]</expression>
<list-property name="sort">
<structure>
<expression
name="key">row["orderdate"]</expression>
</structure>
</list-property>
<header>
<row id="99">
<cell id="100"/>
<cell id="101">
<property name="colSpan">6</property>
<property name="rowSpan">1</property>
<data id="111">
<property
name="style">OrderStyle</property>
<expression
name="valueExpr">row["orderdate"]</expression>
</data>
</cell>
</row>
</header>
<footer>
<row id="105">
<cell id="106"/>
<cell id="107"/>
<cell id="108"/>
<cell id="109"/>
<cell id="110"/>
<cell id="115"/>
<cell id="143"/>
</row>
</footer>
</group>
<group id="121">
<property name="groupName">OrderNumberGroup</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["ordernumber"]</expression>
<list-property name="sort">
<structure>
<expression
name="key">row["ordernumber"]</expression>
</structure>
</list-property>
<header>
<row id="122">
<cell id="123"/>
<cell id="124"/>
<cell id="125">
<property name="colSpan">5</property>
<property name="rowSpan">1</property>
<property
name="style">OrderNumberStyle</property>
<data id="136">
<expression
name="valueExpr">row["ordernumber"]</expression>
</data>
</cell>
</row>
</header>
<footer>
<row id="129">
<cell id="130"/>
<cell id="131"/>
<cell id="132"/>
<cell id="133"/>
<cell id="134"/>
<cell id="135"/>
<cell id="142"/>
</row>
</footer>
</group>
<detail>
<row id="42">
<cell id="43"/>
<cell id="44"/>
<cell id="45"/>
<cell id="46">
<data id="79">
<expression
name="valueExpr">row["productcode"]</expression>
</data>
</cell>
<cell id="47">
<data id="81">
<expression
name="valueExpr">row["productname"]</expression>
</data>
</cell>
<cell id="114">
<data id="83">
<expression
name="valueExpr">row["quantityordered"]</expression>
</data>
</cell>
<cell id="141">
<text-data id="147">
<property name="style">MoneyStyle</property>
<expression name="valueExpr">row["buyprice"] *
row["quantityordered"]</expression>
<property name="contentType">html</property>
</text-data>
</cell>
</row>
</detail>
<footer>
<row id="48">
<property name="height">0.239in</property>
<cell id="49"/>
<cell id="50"/>
<cell id="51"/>
<cell id="52"/>
<cell id="53"/>
<cell id="117"/>
<cell id="145"/>
</row>
</footer>
</table>
</body>
</report>
The export of this report lasts 5 minutes and it doesn't work, because
I've got this error : HTTP 500 and the cach memory is from 120Mo to 350Mo.
After this, I have tried the same bar chart report and it works.
My configuration :
- birt all in one 2.0.1
- XLS-emitter 2.0.1
My PC Configuration :
- Pentium 4 3000
- 1Go DDR
Can you try my example please and tell me if it's a bad working of the XLS
emitter.
It very too bad, because the export of any reports with Jasper reports is
during 30 secondes, but is not very beautiful.
Thank you for your hopping comments and help.
Luc LABBE
|
|
|
Powered by
FUDForum. Page generated in 0.25405 seconds
Home