I have an Apex 4.2 application
that I have been running for years on a windows 2008 Server.
Setup on server :
-Oracle 11.2
-Apex 4.2
-Ords 3.0.2
-Glassfish 4
We have now acquired a
new server, Windows 2016
Setup on server :
Oracle 18C
Apex 19.1
Ords 18_4
Tomcat8_5
I have copied the old
application to the new server. It runs, but ten times slower than on the old
server.
I have turned on Apex debug
on both servers. From the debug log, loading
the same page takes 13,628sec on the new server and 0,749sec on the old server.
The database is faster
on the new servers, returns the same dataset faster than on the new server.
Below I have listed some
of the records that have the highest execution time:
New server:
ELAPSED_TIME EXECUTION_TIME MESSAGE_50
------------ -------------- --------------------------------------------------
13,628 Final commit
7,193 3,121 ... Read Only = false
10,327 2,561 Load JavaScript file=/k/KavFiler/Plugins/PretiusLO
1,623 2,327 ... Read Only = false
4,084 2,132 Load JavaScript file=/i/libraries/jquery-ui/1.12.1
13,083 ,313 select i.* from (select "CHECKBOX","LINKEN","P_KE
1,123 ,248 Rewrite SQL to: select a.* from (select produkt_nr
13,396 ,195 rows loop: 25 row(s)
3,953 ,13 is_printer_friendly: false
Old server:
ELAPSED_TIME EXECUTION_TIME MESSAGE_50
------------ -------------- --------------------------------------------------
0.749 Final commit
0.406 0.343 rows loop: 25 row(s)
0.047 0.016 Show page template body
0.078 0.016 ...Execute Statement: select lpad(kunde_nr,3,'0')|
0.031 0.016 ......Result = TRUE
0 0.016 alter session set NLS_CALENDAR="GREGORIAN"
0.203 0.016 ...Execute Statement: begin declare type column_re
Something strange is that " Load JavaScript file …" entries do not appear in the debug on the old server.
Hope some of you have ideas as to what could be causing this.
Arild