Eclipse Community Forums: BIRT » Performance Problem in Report

Home » Archived » BIRT » Performance Problem in Report

Performance Problem in Report [message #253115]

Tue, 21 August 2007 06:01

Eclipse User

Originally posted by: sjaheer.gmail.com

Hi

while running a report which contains more than 1 lakh records then the
report is taking more than 6 minutes to execute

is anyway to speed up the report executing process even though the no. of
records are more than 1 lakh

Looking forward for help

Thanks

Re: Performance Problem in Report [message #253191 is a reply to message #253115]

Wed, 22 August 2007 00:36

Eclipse User

shaik wrote:
> Hi
> while running a report which contains more than 1 lakh records then the
> report is taking more than 6 minutes to execute
>
> is anyway to speed up the report executing process even though the no.
> of records are more than 1 lakh
>
> Looking forward for help
>
> Thanks
>

Well, after having to look up 'lakh', is there any reason why you need
100,000 records in your report?

I've found performance problems with BIRT (and other systems that load
data in one hit rather than being able to 'cursor' through them, so
BIRT's not at fault here).

The solution I used was to use the SQL query to filter results down to a
decent level (using WHERE clauses) to minimise the amount of data
transmitted across the wire.

Cheers,
Pax.

Re: Performance Problem in Report [message #253250 is a reply to message #253191]

Wed, 22 August 2007 09:19

Eclipse User

Hi,

is really "lakh" an English word?

BIRT takes a heck of a time to generate any reports.

Regards,

Cris

Previous Topic:	[birt-report-designer-dev]Viewing report in web-viewer
Next Topic:	[birt-report-designer-dev]Viewing report in web-viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Mon May 12 22:04:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter