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.
- Increase the number of PL/SQL cartridges in your web server. this makes
things go faster if you have many queries.
- 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 .
- 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