Hi
I have created a application that displays a static report based on the value in tabular Form. To display the static report, i have called AJAX.
In Application process (thru AJAX call), the Sql statement which fetches records for static report based on the column field is working fine in terms of performance at Backend (Oracle 10g), but the same in Apex UI, whenever i navigate to other rows of tabular form, Performance is slow.
It takes about 2 to 3 sec more than Backend time to process and displaying the records.
What could be the reason for this? Please suggest how to overcome this issue.
Eg:
Tabular Form REgion:
R1C1 R1C2 R1C3
R2C1 R2C2 R2C3
R3C1 R3C2 R3C3
Static Report Region:
Value1 Value2
Total: Value3
Based on the column value of current tabular form row, the report would display the values. So whenever we navigate to other row, application takes 2 to 3 sec more than Backend processing time to fetch and display the corresponding Records in Report region.
Thanks
Vijay