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

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

    Milos

      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 4.1.0.00.32

      DB 10.2.0.4.0

      Apex Listener Version: 1.1.3.243.11.40 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


      Thanks.


      Milos.