Eclipse Community Forums: BIRT » Query executed twice - any way to turn off validation for production?

Home » Archived » BIRT » Query executed twice - any way to turn off validation for production?

Query executed twice - any way to turn off validation for production? [message #252550]

Wed, 15 August 2007 11:35

Eclipse User

I am using BIRT 2.2.0 and MySQL 5.0.x.

When I run a report I am seeing the query executed twice in the MySQL
query log. Is there anyway to make this not happen? I am assuming it is
doing this in production where I have embedded BIRT runtime in my
application.

I see this behavior using BIRT RCP Application and previewing the report.

A second related question is I have 1 SQL query that I have embedded into
two tables on my report. Each table executes that same query. Is there a
way to have the query executed once and not twice (actually 4 times with
the behavior described above)?

As background, the report produces two identical sections that are on
perforated paper - 1 copy to client, 1 for permanent our records.

Chris....

Re: Query executed twice - any way to turn off validation for production? [message #252562 is a reply to message #252550]

Wed, 15 August 2007 11:44

Eclipse User

Originally posted by: asdf.asdf.com

Are you creating multiple datasets? if so you can try using a single
DataSet for both the tables.

Re: Query executed twice - any way to turn off validation for production? [message #252566 is a reply to message #252562]

Wed, 15 August 2007 11:55

Eclipse User

No - I am using 1 dataset.

In the first question, I have noticed that the dataset is getting executed
twice (in all of my reports). It appears that the first execution is a
validation query and the second execution is to retrieve the data. Once
the reports are developed, is there a way to turn off the validation
execution?

In the second question, is there a way to have a dataset bound to two
different tables on the same report and have the dataset executed only
once?

Thanks,
Chris....

Re: Query executed twice - any way to turn off validation for production? [message #252570 is a reply to message #252566]

Wed, 15 August 2007 13:38

Eclipse User

Originally posted by: asdf.asdf.com

I am not sure about the first question but my previous experience with
BIRT 2.2 until(2.2 M6) is that when the data set query does not change it
uses the cached data , and this happens by default, so I think having the
same dataset bound to different tables should execute query once for both
the tables (excluding the execution for validation).

Thanks.. let me know if your findings

Re: Query executed twice - any way to turn off validation for production? [message #252679 is a reply to message #252550]

Wed, 15 August 2007 21:41

Eclipse User

The query is executed twice maybe because two tables may have different
filter or some other script so that they will have different data rows for
return.

In BIRT2.2.1, share result set will be supported, it means that your two
tables can share the same result set so that query will be executed only
once. I think that can resolve the issue.

Thanks.

"Chris Hane" <chrishane@gmail.com> wrote in message
news:058543be79272fd74dcc756e83b72492$1@www.eclipse.org...
>
> I am using BIRT 2.2.0 and MySQL 5.0.x.
>
> When I run a report I am seeing the query executed twice in the MySQL
> query log. Is there anyway to make this not happen? I am assuming it is
> doing this in production where I have embedded BIRT runtime in my
> application.
>
> I see this behavior using BIRT RCP Application and previewing the report.
>
>
> A second related question is I have 1 SQL query that I have embedded into
> two tables on my report. Each table executes that same query. Is there a
> way to have the query executed once and not twice (actually 4 times with
> the behavior described above)?
>
> As background, the report produces two identical sections that are on
> perforated paper - 1 copy to client, 1 for permanent our records.
>
> Chris....
>

Re: Query executed twice - any way to turn off validation for production? [message #252690 is a reply to message #252679]

Wed, 15 August 2007 22:10

Eclipse User

lchen wrote:

> The query is executed twice maybe because two tables may have different
> filter or some other script so that they will have different data rows for
> return.

That's what I thought and that is understandable.

> In BIRT2.2.1, share result set will be supported, it means that your two
> tables can share the same result set so that query will be executed only
> once. I think that can resolve the issue.

Looking forward to 2.2.1, that will help with performance on some of my
reports.

Will there be a way to turn off the query execution for validation in
2.2.1?

Thanks,
Chris....

Previous Topic:	row._outer problem
Next Topic:	RE API 2.2: Report engine can not create html emitter

Goto Forum:

-=] Back to Top [=-

Current Time: Wed May 14 15:24:35 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter