Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Fast First Page

Show: Today's Messages :: Show Polls :: Message Navigator

Fast First Page [message #302777]

Mon, 28 January 2008 09: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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 18 03:21:48 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter