Performance degradation after migration from Oracle Forms 5.0.6.8 Oracle Forms to Forms Version 11.1
Performance degradation after migration from Oracle Forms 5.0.6.8 Oracle Forms to Forms Version 11.1.2.1.0.We have migrated a form that returns from 1 to 6000 rows after execute query on the specific data block.
If query return small number of rows the form/block is populated very fast (< 1sec).
If query return more than 1000 rows the form/block is populated too slow (to populate 6000 rows it takes about 30sec).
We didn’t experience such a slow performance in the previous version of form with exactly the same query and block property.
What steps should we take (block property, hints etc…) to improve the form performance?
If query return small number of rows the form/block is populated very fast (< 1sec).
If query return more than 1000 rows the form/block is populated too slow (to populate 6000 rows it takes about 30sec).
We didn’t experience such a slow performance in the previous version of form with exactly the same query and block property.
What steps should we take (block property, hints etc…) to improve the form performance?
0