Eclipse Community Forums: BIRT

Home » Archived » BIRT » Fast First Page

Mon, 28 January 2008 04:10

Eclipse User

Originally posted by: tigeleo.yahoo.com

Hello.

I use Birt to make online report for SQL query that return much results.
In query I use hint /*+ FIRST_ROWS */

In SQLPlus I start get results immediate. But when I use the query in
Birt, it run hours...
It meen that Birt try run all query before write first page.
What I need to config to get first page immediate...

I set also "max number of rows to fetch from data set" = 200 (page size of
my report)

Thanks.

Re: Fast First Page [message #339090 is a reply to message #327678]

Mon, 28 January 2008 10:07

Eclipse User

Originally posted by: tigeleo.yahoo.com

David ?????:
> Hello.
>
> I use Birt to make online report for SQL query that return much results.
> In query I use hint /*+ FIRST_ROWS */
>
> In SQLPlus I start get results immediate. But when I use the query in
> Birt, it run hours... It meen that Birt try run all query before write
> first page.
> What I need to config to get first page immediate...
>
> I set also "max number of rows to fetch from data set" = 200 (page size
> of my report)
>
> Thanks.
>
I also see that Preview Result work fast.
But when I try run report , query run 4 hours..

Re: Fast First Page [message #339165 is a reply to message #327678]

Mon, 28 January 2008 10:07

Eclipse User

Previous Topic:	Fast First Page
Next Topic:	Fast First Page

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 14:49:51 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter