Eclipse Community Forums: BIRT » SQL Query changes take long

Home » Archived » BIRT » SQL Query changes take long

SQL Query changes take long [message #629409]

Tue, 28 September 2010 03:48

Eclipse User

Hi!

Everytime I change the SQL-query of a DataSet and then go to another tab (for example "Preview Results" or "Propertys") or create a new DataSet, BIRT freezes for several minutes.
It doesn't matter if the query causes an error or not, it always freezes.

The querys themselfes are not very complex. Just nvl, decode, joins, order by.

What does BIRT do after a query is changed? Can I somehow disable it?

Database: Oracle 10g 64bit
Driver Class: oracle.jdbc.OracleDriver (v11.2)
BIRT Version: 2.6.0 (also with 2.5.2)

Peter

Re: SQL Query changes take long [message #629777 is a reply to message #629409]

Wed, 29 September 2010 10:22

Eclipse User

Peter,

I have not seen this problem. When you modify the query data engine
re-executes the query and updates the metadata in the design. If you do
a simple select * from table do you get the issue?

Jason

On 9/28/2010 3:48 AM, peter@pilgerstorfer.at wrote:
> Hi!
>
> Everytime I change the SQL-query of a DataSet and then go to another tab
> (for example "Preview Results" or "Propertys") or create a new DataSet,
> BIRT freezes for several minutes. It doesn't matter if the query causes
> an error or not, it always freezes.
>
> The querys themselfes are not very complex. Just nvl, decode, joins,
> order by.
>
> What does BIRT do after a query is changed? Can I somehow disable it?
>
> Database: Oracle 10g 64bit
> Driver Class: oracle.jdbc.OracleDriver (v11.2)
> BIRT Version: 2.6.0 (also with 2.5.2)
>
> Peter

Re: SQL Query changes take long [message #685466 is a reply to message #629777]

Fri, 17 June 2011 10:58

Eclipse User

This behaviour is really annoying, I think the design assumption that you can execute the query at "any time" is flawed (executing some of my queries takes several (dozen) minutes).

Is there a way to avoid this? I tried breaking the connection to the DB server, but then BIRT Report Designer tends to freeze/crash.

Re: SQL Query changes take long [message #685604 is a reply to message #685466]

Fri, 17 June 2011 16:53

Eclipse User

Tomas,

Can you open a bug for this?

Jason

On 6/17/2011 10:58 AM, Tomas wrote:
> This behaviour is really annoying, I think the design assumption that
> you can execute the query at "any time" is flawed (executing some of my
> queries takes several (dozen) minutes).
> Is there a way to avoid this? I tried breaking the connection to the DB
> server, but then BIRT Report Designer tends to freeze/crash.

Previous Topic:	Drill-Through
Next Topic:	Create pie chart programatically?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 17:19:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter