Eclipse Community Forums: BIRT » Slow dataset definition

Home » Archived » BIRT » Slow dataset definition

Slow dataset definition [message #201566]

Fri, 17 November 2006 04:49

Eclipse User

When I use BIRT report designer (2.1.1) to connect to a big database
with a lot of shemas an tables, the table definition dialog is very slow.

Somebody else is experiencing with this problem? Is there any workaround?

Thank you,
Paolo Di Tommaso

Re: Slow dataset definition [message #201793 is a reply to message #201566]

Mon, 20 November 2006 03:26

Eclipse User

Originally posted by: johnw.innoventsolutions.com

Paolo Di Tommaso wrote:
> When I use BIRT report designer (2.1.1) to connect to a big database
> with a lot of shemas an tables, the table definition dialog is very slow.
>
> Somebody else is experiencing with this problem? Is there any workaround?
>
>
> Thank you,
> Paolo Di Tommaso
Paolo,

What database are you using? I have only experienced this on Oracle.

John

Re: Slow dataset definition [message #201954 is a reply to message #201566]

Mon, 20 November 2006 11:59

Eclipse User

Paolo,

How many schema/tables are in your database? You may want to consider
using the dialog found at:
Windows => Preferences => Report Design => Data Set Editor
=> JDBC Data Set

Once there you can change the Maximum number of schemas to display and
Maximum number of tables in each scheme to display.

The downside is that you will have to start to use the filter dialog to
pick the tables you want.

Scott Rosenbaum

Paolo Di Tommaso wrote:
> When I use BIRT report designer (2.1.1) to connect to a big database
> with a lot of shemas an tables, the table definition dialog is very slow.
>
> Somebody else is experiencing with this problem? Is there any workaround?
>
>
> Thank you,
> Paolo Di Tommaso

Re: Slow dataset definition [message #202367 is a reply to message #201793]

Wed, 22 November 2006 03:58

Eclipse User

I'm using Oracle .. !

Anyway Scott have suggested me to use the "Maximum number of schemas to
display" option in the JDBC Data Set preference page.

This solve in some way the problem.

Paolo

> Paolo Di Tommaso wrote:
>> When I use BIRT report designer (2.1.1) to connect to a big database
>> with a lot of shemas an tables, the table definition dialog is very slow.
>>
>> Somebody else is experiencing with this problem? Is there any workaround?
>>
>>
>> Thank you,
>> Paolo Di Tommaso
> Paolo,
>
> What database are you using? I have only experienced this on Oracle.
>
> John

Previous Topic:	make the query dynamic???
Next Topic:	Integrating Reports with Application

Goto Forum:

-=] Back to Top [=-

Current Time: Sat May 10 21:19:19 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter