icon-arrow icon-check icon-mail icon-phone icon-facebook icon-linkedin icon-youtube icon-twitter icon-cheveron icon-download icon-instagram play close icon-arrow-uturn icon-calendar icon-clock
Werken bij Whitehorses
Blog 11/10/2012

Slow loading of tabular forms in Application Express

Slow loading

Integratiespecialist
Patrick Sinke /
Integratiespecialist

Under some circumstances, there is an issue (observed in Application Express 4.1.1.00.23) that page tabular forms take very long to load, up to several minutes. Even if there is a very small dataset in the underlying table.  When I encountered this issue, the report ran fine on Development en Test environments, but in the almost identical production environment the page took minutes to load.

When examining the debug, I found the following line of Apex generated code, taking up to 30 seconds:

begin 
   select /*+ cardinality(t 10) */ 
         disp
       , val 
         bulk collect 
   into wwv_flow_utilities.g_display
      , wwv_flow_utilities.g_value 
   from table(wwv_flow_utilities.get_temp_lov_data(4)) t 
   order by insert_order, disp; 
end;

The main culprit appears to be the wwv_flow_utilities.get_temp_lov_data. This function is called whenever you create an item of the type “Select List (Named LOV)”. The workaround I found is to change the type to “Select List (Query Based LOV)” or “Select List (Static LOV)”. After altering the report attribute type, the report is loading normally.

Report Attributes

Downside is that it will make your code less maintainable. Hopefully the problem is fixed in Apex 4.2.

Overzicht blogs

Geen reacties

Geef jouw mening

Reactie plaatsen

Reactie toevoegen

Jouw e-mailadres wordt niet openbaar gemaakt.

Geen HTML

  • Geen HTML toegestaan.
  • Regels en alinea's worden automatisch gesplitst.
  • Web- en e-mailadressen worden automatisch naar links omgezet.
Integratiespecialist
Patrick Sinke /
Integratiespecialist

Wil je deel uitmaken van een groep gedreven en ambitieuze integratiespecialisten? Stuur ons jouw CV!