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
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

