Eclipse Community Forums: BIRT » Slow dataset definition

Help

Home

Home » Archived » BIRT » Slow dataset definition

Show: Today's Messages :: Show Polls :: Message Navigator

Slow dataset definition [message #201566]

Fri, 17 November 2006 09:49

paolo di tommaso

Messages: 22
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Mon, 20 November 2006 08: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

Report message to a moderator

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

Mon, 20 November 2006 16:59

Scott Rosenbaum

Messages: 425
Registered: July 2009

Senior Member

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

Report message to a moderator

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

Wed, 22 November 2006 08:58

paolo di tommaso

Messages: 22
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 06 12:07:02 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter