{"id":125,"date":"2016-10-19T19:25:15","date_gmt":"2016-10-19T17:25:15","guid":{"rendered":"http:\/\/geekinto.com\/?p=125"},"modified":"2016-10-19T19:25:15","modified_gmt":"2016-10-19T17:25:15","slug":"oracle-apex-speed-up-your-apex","status":"publish","type":"post","link":"https:\/\/howoracleapex.com\/?p=125","title":{"rendered":"Oracle Apex: Speed up your APEX"},"content":{"rendered":"

Sometimes<\/strong> i find my Apex is so slow when saving changes after development into Design page, It was from my problems,<\/p>\n

Now i find cause that it was\u00a0(Off\u00a0Gzip compression)<\/strong> into local server configuration like GlassFish Server [By Default: Off\u00a0Gzip compression], To fix it please Enable\u00a0Gzip compression into all network listeners,<\/p><\/blockquote>\n

Network listeners<\/strong> > [Choose your listener] > HTTP<\/strong> tab > looking for\u00a0Compression <\/strong>and Choose On<\/strong><\/p>\n

\"x1\"<\/a>
\n<\/strong><\/p>\n

 <\/p>\n

\"x2\"<\/a>
\n<\/strong><\/p>\n

 <\/p>\n

For more optimization when using [ORDS]\u00a0..<\/strong><\/em>
\nOptimize ORDS By Edit some ENTRY’s into \/ords\/default.xml<\/strong><\/em><\/p>\n

<entry key=\"jdbc.InitialLimit\">10<\/entry>  \r\n<entry key=\"jdbc.MinLimit\">15<\/entry>  \r\n<entry key=\"jdbc.MaxLimit\">60<\/entry>  \r\n<entry key=\"jdbc.MaxStatementsLimit\">10<\/entry>  \r\n<entry key=\"apex.jdbc.DriverType\">thin<\/entry>  \r\n<entry key=\"apex.jdbc.InitialLimit\">15<\/entry>  \r\n<entry key=\"apex.jdbc.MinLimit\">15<\/entry>  \r\n<entry key=\"apex.jdbc.MaxLimit\">10<\/entry>  \r\n<entry key=\"apex.jdbc.InactivityTimeout\">1800<\/entry>  \r\n<entry key=\"apex.jdbc.AbandonedConnectionTimeout\">900<\/entry>  \r\n<entry key=\"apex.jdbc.MaxConnectionReuseCount\">5000<\/entry>  \r\n<entry key=\"apex.security.requestValidationFunction\">wwv_flow_epg_include_modules.authorize<\/entry><\/pre>\n
Now my Apex like a ROCKET \ud83d\ude42<\/p>\n
APEX \u00a0\ud83d\ude42
\nThank\u00a0you
\nMahmoud_Rabie
\n<\/a> joelkallman-Oracle
\n<\/a> Kiran Pawar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
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\u00a0(Off\u00a0Gzip compression) into local server configuration like...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,16,19],"tags":[30,27,26,29,28],"class_list":["post-125","post","type-post","status-publish","format-standard","hentry","category-apex","category-glassfish","category-linux","tag-apex","tag-compression","tag-glassfish","tag-oracle","tag-ords"],"_links":{"self":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=125"}],"version-history":[{"count":2,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/125\/revisions"}],"predecessor-version":[{"id":129,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=\/wp\/v2\/posts\/125\/revisions\/129"}],"wp:attachment":[{"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howoracleapex.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}