Oracle Apex: Speed up your APEX

Sometimes i find my Apex is so slow when saving changes after development into Design page, It was from my problems,

Now i find cause that it was (Off Gzip compression) into local server configuration like GlassFish Server [By Default: Off Gzip compression], To fix it please Enable Gzip compression into all network listeners,

Network listeners > [Choose your listener] > HTTP tab > looking for Compression and Choose On

x1

 

x2

 

For more optimization when using [ORDS] ..
Optimize ORDS By Edit some ENTRY’s into /ords/default.xml

<entry key="jdbc.InitialLimit">10</entry>  
<entry key="jdbc.MinLimit">15</entry>  
<entry key="jdbc.MaxLimit">60</entry>  
<entry key="jdbc.MaxStatementsLimit">10</entry>  
<entry key="apex.jdbc.DriverType">thin</entry>  
<entry key="apex.jdbc.InitialLimit">15</entry>  
<entry key="apex.jdbc.MinLimit">15</entry>  
<entry key="apex.jdbc.MaxLimit">10</entry>  
<entry key="apex.jdbc.InactivityTimeout">1800</entry>  
<entry key="apex.jdbc.AbandonedConnectionTimeout">900</entry>  
<entry key="apex.jdbc.MaxConnectionReuseCount">5000</entry>  
<entry key="apex.security.requestValidationFunction">wwv_flow_epg_include_modules.authorize</entry>

Now my Apex like a ROCKET 🙂

APEX  🙂
Thank you
Mahmoud_Rabie
joelkallman-Oracle
Kiran Pawar

You may also like...