APEX Listener and Caching

915154 Nov 29, 2012 7:30 PM

I'm having a discussion with a colleague (ok an argument) so I have a basic question about the APEX Listener and caching for the forum. Our current environment is:

OHS 11g (with the weblogic plug-in) --> WebLogic 11g (with APEX Listener deployed) --> Oracle 11g (APEX packages deployed).

The user goes to the APEX URL via the browser, it's forwarded by the weblogic plug-in to the APEX Listener, which in turn forwards it to the DB. The APEX application processes the request and does its thing to generate an HTML page and returns it eventually to the browser. On and on, etc.

My question is this. Does the APEX listener in this type of scenario send any application specific sql or pl/sql calls to the Database (other than dealing with the connection pool) for processing by the application or does it just act as a proxy and forward HTML to the database for processing by the DB/APEX application which does all the pl/sql calls?

My colleague wants to turn on caching on the APEX Listener but I'm thinking this won't help because I assumed that the listener doesn't generate any application specific SQL or PL/SQL calls to be cached.

Thanks,

rowdycholin

1. Re: APEX Listener and Caching

Prabodh Nov 30, 2012 11:30 AM (in response to 915154)

Apex Listener version?
Have you read the Defining Caching section in 1.1 Installation Guide?

Caching ought to help if you have file based content. It will not do any harm for sure.

Cheers,
Like Show 0 Likes(0)

Actions
2. Re: APEX Listener and Caching

915154 Nov 30, 2012 1:35 PM (in response to Prabodh)

thanks for the reply. Looks like it caches file content and not SQL.

The listener is

APEX Listener version : 1.1.3.243.11.40
Like Show 0 Likes(0)

Actions
3. Re: APEX Listener and Caching

Prabodh Dec 1, 2012 8:29 AM (in response to 915154)

Yes, file content and that too fetched through db procedures.
You have a choice of deployment when to comes to static files like images, css,etc. You could deploy them on OHS or WLS and their caching will be handled by OHS or WLS , respectively.

For SQL and DB calls there is the Connection Pool.

Cheers,
Like Show 0 Likes(0)

Actions

Go to original post