Forum Stats

  • 3,852,732 Users
  • 2,264,130 Discussions
  • 7,905,127 Comments

Discussions

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

Milos
Milos Member Posts: 25
edited Jul 30, 2013 2:56AM in APEX Discussions

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.

Tagged:

Answers

This discussion has been closed.