| Fast First Page [message #340955] |
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 #346600 is a reply to message #340955] |
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 #346675 is a reply to message #340955] |
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 #350968 is a reply to message #340955] |
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 #351044 is a reply to message #340955] |
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..
|
|
|
Powered by
FUDForum. Page generated in 0.04166 seconds
Home