Re: Caching of OWA

Hi Muchacho

  "Nicodemus Chan" <nicodemus_at_pacific.net.sg> wrote:
> Is there anyway to cache the results of a query to an Oracle Web Application
> server so as to save processing time?

A bit vague, therfore there are several answers to your query.

1. Increase the number of PL/SQL cartridges in your web server. this makes things go faster if you have many queries.
2. The normal optimisation rules of the database still apply, if you wack the database with the query a few times, the buffering , + database cache should be operational, I presume you have done an explain plan on your query and optimised it for performance,( avoided full table scans) have you set up indexes? etc .
3. Strip down the html tags to a level that will make the final html file as small as possible. In other words use the html to produce a simple and plain result set. Do not use complex structures to display your results. Remember an html file over 30k-40k is starting to push it a bit, over the itnernet, on an intranet you can make it bigger.

Hope this helps

Adios

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Sep 30 1998 - 12:56:37 CDT