APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Poor performance for report with 1.7 Million records (with pagination)

588030Apr 29 2008 — edited Nov 19 2008

I have APEX report page based on query that pulls up 1.7 million records. Though I have set number of rows per page as 15, looks like it is pulling entire set of 1.7 million records. If I run the same query in sql workshop of apex it executes in 0.40 secords pulling first 10 records.

Time taken by page: 6 minutes
Time taken by SQL Workshop: 0.40 secords
Time taken by Toad/plsql developer : 0.3 seconds

I have selected X to Y pagination.
Is there anyway to make report only query first 10-15 records initially or set some property to make report retrieve faster. Please help. I have 65 more reports to be developed and majority of them deal with high volume of data.

Thank you.
Prashant
4084311331

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2008

Added on Apr 29 2008

#apex, #apex-discussions, #installation, #performance, #sql-developer

22 comments

2,878 views