Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 555 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 533 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
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 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.
Answers
-
Use the APEX Listener.. Mod_plsql is not really the best any longer and will probably be de-supported soon... EPG, better for development situations, NOT production usage..
Thank you,
Tony Miller
Ruckersville, VA
-
Tony, thanks.
-
So I returned after a long time on this issue.
Sets the delay in the evaluation of conditions "Exists (SQL return at least one rows)"
apex execute the following command:select count(*) from dual where exists (select * from [email protected] A, usys_odpocty B where A.RBMP_ID = B.RBMP_ID and RBMP_RB_ID = :P32_CISLO)delay of this comand is more as 5 sec.but select into text array of conditions:select * from [email protected] A, usys_odpocty B where A.RBMP_ID = B.RBMP_ID and RBMP_RB_ID = :P32_CISLOhave delay 0,01sec.I trying alternative select ( select distinct 1 from ....) but the same result delay.Advice please?Milos. -
Have you tried the select in sql developer or TOAD? Going over the DBLINK might be the issue you are running into...
Thank you,
Tony Miller
SmartDog Services
Austin, Texas
-
I was trying run this script:
select count(*) from dual where exists (select * from [email protected] A, usys_odpocty B where A.RBMP_ID = B.RBMP_ID and RBMP_RB_ID = :P32_CISLO)
into console ( sqlplus.exe ), delay is about 5 sec.
but this script:
select 1 from dual where exists (select * from [email protected] A, usys_odpocty B where A.RBMP_ID = B.RBMP_ID and RBMP_RB_ID = :P32_CISLO)
delay is just few miliseconds.
Thanks.
Milos.
-
I was trying to analyze the table, recreate the index - but no change in time result.
How to replace it with PL/SQL Expression type ?
Thanks.
Milos.