This discussion is archived
2 Replies Latest reply: Jan 28, 2013 3:58 AM by Christian Neumueller RSS

Apache Proxy Introducing Delays

athlonrob Newbie
Currently Being Moderated
Good Afternoon-

I recently set up APEX 4.2 via the EPG. As I don't want to directly expose the database server to customers, I'm running it through Apache with the following proxy lines:

ProxyPass /apex http://backend-db:8080/apex
ProxyPassReverse /apex http://backend-db:8080/apex
ProxyPass /i http://backend-db:8080/i
ProxyPassReverse /i http://backend-db:8080/i

I also have /i available to be served locally, but I found APEX is passing some parameters on to some of the static resources, which Apache doesn't much care for with static resources.

I'm experiencing some significant delays when running it, however. When I access /apex, I'm 302 redirected to /apex/apex. That redirect takes a few seconds to be sent back to my browser. /apex/apex then takes about twice as long to redirect me to f?p=4550..... which returns a 200 and data in about three seconds. Additional resources are loaded in miliseconds.

In my testing, when I hit the backend DB directory, I'm finding these initial redirects generally take a few ms instead of several seconds. It is pretty regularly repeatable. Any thoughts as to why the Apache proxy would introduce so much delay?

Thanks...

Rob
  • 1. Re: Apache Proxy Introducing Delays
    jariola Guru
    Currently Being Moderated
    Hi,

    You should try remove below lines and serve static content from Apache not from DB
    ProxyPass /i http://backend-db:8080/i
    ProxyPassReverse /i http://backend-db:8080/i
    Unload all modules from Apache you do not use.

    It is hard give any good advice without full details about environment.
    What is e.g. database version and edition?
    What is APEX version?
    What is Apache version?


    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 2. Re: Apache Proxy Introducing Delays
    Christian Neumueller Expert
    Currently Being Moderated
    Hi,

    these documents should help you tune the shared server configuration:

    http://docs.oracle.com/cd/E11882_01/server.112/e16638/build_db.htm#PFGRF021
    http://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc003.htm

    Typically, serving static content via Apacha (as Jari mentioned) and some tweaks of the shared server parameters give quite acceptable performance if the load is not too heavy. However, you should investigate switching to Apex Listener or OHS / mod_plsql, if security and scaling is an issue.

    Regards,
    Christian

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points