6 Replies Latest reply on Jul 30, 2013 6:56 AM by Milos

    long time opening pages with conditions "Exist (SQL query ret..)" ( edit )


      Hi all!


      I have report with multiple text arrays ( 3 columns , 50 - 200 rows).

      Everything works fine, but the page for a long time generating ( 12-15 sec.)


      I need advice on how to accelerate.



      Apex Listener Version: on different machine


      I plan to update the apex to version 4.2 , database to 11 g.

      What web listener should I use in new instalation ?


      - Oracle Application Express Listener

      - Embedded PL/SQL gateway

      - Oracle HTTP Server and mod_plsql