Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
5 thousands record, 1 minute
stf
Hello, everyone
I designed a birt report, using scripted data source - scripted data set.
The data is put in the session, and I use fetch() method of the scripted data set to fetch all the records, and display them in a crosstab.
The record number is about 5,000, and it takes about 1 minute to display the records (timing when the window displaying "processing, please wait" shows).
Is it too slow ? And how can i improve the performance?
Find more posts tagged with
Comments
mwilliams
Hi stf,
Is this in the designer? Or deplayed to the viewer? You could put in some sort of logging function into your report and check how long it's taking to do certain steps in your report creation, like fetching data, etc. Then you'd have a better idea of what's taking the most time and if there's anything you can do to improve that.
stf
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>Hi stf,<br />
<br />
Is this in the designer? Or deplayed to the viewer? You could put in some sort of logging function into your report and check how long it's taking to do certain steps in your report creation, like fetching data, etc. Then you'd have a better idea of what's taking the most time and if there's anything you can do to improve that.</p></blockquote>
<br />
Hi <strong class='bbc'>mwilliams</strong>,<br />
The report design is running in the viewer and the pattern is frameset.<br />
I put the logging functions in the script functions of report designs/items/.. as you said, and get the logs describing the executing time of each funtions.<br />
The total time needed(from the generation phase to the layout of data in IE) is about 66.5s,the record number is 16767.<br />
The dataset fetch(), onPrepare() of report items take little time.<br />
crosstab onCreate() takes 7s.<br />
crosstab onRender()takes 5s.<br />
The total time consumed in generation phase and presentation phase(from initialize() to afterRender() of ReportDesign) takes15.5s<br />
After the presentation phase(afterRender() ends), it takes another 51s to show records in IE.<br />
<br />
Obviously, after the presentation phase, the export to IE in html format takes the most time.How can i do to decrease the time?<br />
Thank you in advance!
mwilliams
stf,
Is this just the first time you run the report? What if you re-run the report from the toolbar, how long does it take? If you click from page 1 to page 2 in the report, is there a long pause to render the report? If it runs much faster the second time, it could just be the setup of the viewer frameset that's taking so long. This will sometimes be the case on the first run.
How quickly does it run if you use the run option rather than frameset? Also, what are you displaying in each row? Just straight data? Or images and/or coded values?
Let me know.
stf
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>stf,<br />
<br />
Is this just the first time you run the report? What if you re-run the report from the toolbar, how long does it take? If you click from page 1 to page 2 in the report, is there a long pause to render the report? If it runs much faster the second time, it could just be the setup of the viewer frameset that's taking so long. This will sometimes be the case on the first run.<br />
<br />
How quickly does it run if you use the run option rather than frameset? Also, what are you displaying in each row? Just straight data? Or images and/or coded values?<br />
<br />
Let me know.</p></blockquote>
<br />
mwilliams,<br />
I deployed the birt report in my dynamic web project.No matter how many times I run the report or re-run it by clicking F5 to refresh it, the time consuption is the same.<br />
All the record are in the same page, there's only one page.<br />
<br />
If I use the run option, the time consumption is as following:<br />
crosstab onCreate AND onRender:6-7s<br />
the whole stage(from initialize() to afterRender()):7-8s<br />
records show in html:49s <br />
<br />
The data in each row and column of the crosstab are from java object, and they are in String,Integer Type.
mwilliams
stf,
So, you gain some time by running in straight HTML vs in the viewer framework, but not much. I can't say I've seen this issue before, where BIRT is done rendering the report but it still takes this long to show the report. Have you tried using a different browser to see if the time changes any?
stf
mwilliams,
I use firefox, It also takes about 50s.
I guess the report is exported in html format, just as exported in pdf/doc... format.
Otherwize, is it because the report data is put in the session?
Shasha
Hi.. Same issue for me also.. using frameset my page is displaying data after 1-2 min..
BUt the catch is that.. for the fisrt 5-6 refreshes my data is coming <2sec but after that for 1 time it is again coming for >2 min.. again then for few refreshes <2 sec.. n this continues...
this is only when i use BIRT viewer tag..
when i use BIRT report tag it works fine and data is coming <2 sec
Shasha
Hi.. Same issue for me also.. using frameset my page is displaying data after 1-2 min..
BUt the catch is that.. for the fisrt 5-6 refreshes my data is coming <2sec but after that for 1 time it is again coming for >2 min.. again then for few refreshes <2 sec.. n this continues...
this is only when i use BIRT viewer tag..
when i use BIRT report tag it works fine and data is coming <2 sec
mwilliams
So, if you use frameset, it takes 1-2 minutes, but if you use "run", it comes in less than 2 seconds? Can you create a report with the sample database that has this same issue for you and post it in here. Also let me know your BIRT version. Thanks!
Shasha
HI mwilliams..
Thanks for reply but their was not problem with BIRT.
Its related to logger i incoorpertaed with my project.. now everything is working fine...
new problem now..
how to set page number on right side for odd pages and on left side for even pages...
suppose i have to bind a book in that we need format like that only
mwilliams
What is your BIRT version? I think there are some page numbering bugs in versions before 2.6.2 or something that might keep this from working in certain instances, but you can alter the display property of an element based on the page number in the onRender script. Let me know your version and I'll try to set it up for you, in an example.
Shasha
Hi..
Thanks for helping me out.:)
I am using BIRT 3.7 with eclipse Indigo.
mwilliams
Take a look at this design. The page number elements in the masterpage footer are made to alternate using code in the onRender script. Let me know if you have questions.
Shasha
Thanks a lot mwilliams..
mwilliams
You're very welcome! Let us know whenever you have questions!
