Report Pages [message #88111] |
Sun, 17 March 2002 14:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
KK
Messages: 24 Registered: March 2002
|
Junior Member |
|
|
Hi!!
I am using Reports 6i.
When the report is run from Developer, it takes about 5-10 mins (which is fine) to return the first page, when I click to go to the next page, it takes another 5-10 mins. Any ideas why it might be doing this every time I go to the next page?
Any help is appreciated!! Thanks!!
|
|
|
|
Re: Report Pages [message #88117 is a reply to message #88111] |
Fri, 22 March 2002 00:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
rama krishna
Messages: 97 Registered: December 2001
|
Member |
|
|
its not that ur form is taking time to call ur report. its ur reports select statement is taking time to fetch records. every time it fetches only no. of records that fits in the first page. so try tuning ur sql statement and not the system configuration....
by using hints or by using client side filters...
cheers
ram
|
|
|