Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Query result limit(Does birt have a limit on the number of rows it can display?)
Query result limit [message #1785789] Thu, 19 April 2018 22:19 Go to next message
Esper Anza is currently offline Esper AnzaFriend
Messages: 5
Registered: January 2018
Junior Member
Hello
Background
***********
> Using Birt v4.6.0 free version
> Postgres database
> Using crosstab in report to display query results
> Max of 384,357 rows returned from my query

Problem
*******
When displaying the data, birt displays a timeout error after a delay of about 10 to 15 minutes. user is unable to access the data via Birt so I had to execute the query directly via PgAdmin and export to csv

Question
********
1) Does birt have a threshold of the max rows that it can display?
2) The query behind the report consists of several CTEs. Does Birt allow the use of stored procedures? Maybe that would improve performance?
3) What other performance measures can be taken to improve performance and get the data displayed for the user?
4) Is there a paid version of Birt (maybe with more capabilities than the free version) ?

Thank you all for your time
Re: Query result limit [message #1785828 is a reply to message #1785789] Fri, 20 April 2018 11:22 Go to previous messageGo to next message
Eric Davis is currently offline Eric DavisFriend
Messages: 9
Registered: March 2018
Junior Member
This has been discussed here before.

https://www.eclipse.org/forums/index.php/m/1650434/?srch=timeout#msg_1650434
Re: Query result limit [message #1785865 is a reply to message #1785828] Sat, 21 April 2018 04:43 Go to previous message
Esper Anza is currently offline Esper AnzaFriend
Messages: 5
Registered: January 2018
Junior Member
Hi Eric Davis
Thank you for your reply but the link only answers Q3 of my 4 listed questions

[Updated on: Sat, 21 April 2018 04:43]

Report message to a moderator

Previous Topic:create Data Source with .csv
Next Topic:BIRT Runtime:-Cannot open connection to the driver error
Goto Forum:
  


Current Time: Mon Nov 19 06:08:07 GMT 2018

Powered by FUDForum. Page generated in 0.02229 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top