|
Re: SQL Query changes take long [message #629777 is a reply to message #629409] |
Wed, 29 September 2010 14:22 |
|
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 #685604 is a reply to message #685466] |
Fri, 17 June 2011 20:53 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03512 seconds