Hi All,
I have an APEX application Page - Tabular page with a search parameters on a separate top region for searching on the tabular form.
The Tabular form is based on a view and the results/search results itself runs ok, I think.
But the initial launch of the page takes a long time to render anywhere to 8-10 min....
I am trying to analyze what could be causing the performance issue
The tabular form only has 3 updateable fields 2 of them are pure Text field and one is a Select List on a Query.
I have done the following - reduced the number of rows to fetch to 100 ( originally it was 500)
and no of rows to display to 10 (originally it was 25)
and did debug on the page while running
On the first debug - I saw that the max execution time was where it was getting the Select list populated...
| Elapsed | Execution | Message | Level |
| 23.18117 | 0.00226 | rows loop: 10 row(s) | 4 |
| | | |
| 23.18343 | 576.5403 | ...Execute Statement: begin begin SELECT Meaning DisplayVal ,Lookup_Code bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value FROM fnd_lookup_values WHERE lookup_type = 'XYZ' AND enabled_flag = 'Y' AND NVL(start_date_active,TRUNC(SYSDATE-1)) <= TRUNC(SYSDATE) AND NVL (end_date_active,TRUNC(SYSDATE+11)) >= TRUNC(SYSDATE) AND tag IS NULL ; end;
end; | 4 |
So, to confirm if the Select List not the issue, I removed the Select List on the item and made it a Text Field and Re-run the application with debug on.
It still takes 8-10 min for some reasons..
the debug shows as below:
| Elapsed | Execution | Message | Level |
| 22.00142 | 539.20553 | rows loop: 10 row(s) | 4 |
So, I am unable to understand, what is actually causing the peformance issue..
Can someone help me or any suggestions...???
I totally appreciate all your help and support in advance!!
Thanks
Deepa