Fast First Page [message #340280] |
Mon, 28 January 2008 09:10 ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #345699 is a reply to message #340280] |
Mon, 28 January 2008 15:07 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #345774 is a reply to message #340280] |
Mon, 28 January 2008 15:07 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #349914 is a reply to message #340280] |
Mon, 28 January 2008 15:07 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 #349989 is a reply to message #340280] |
Mon, 28 January 2008 15:07 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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.04050 seconds