hi
what servlet engine are you using? There is an application server called
Dynamo from ATG which has precisely the things you are looking for. It is
called relational views system. Even though a application server might be a
little too costly for your purpose, you could take a look at the product
and bulid something like that on your own. You can get a 30 day evaluation
copy free from their site
regards
Anup
At 01:07 PM 7/20/00 -0700, you wrote:
>I'm currently building a web-based intranet that will serve 30-100 people
>all day long (the ability to scale should be preserved, though). Each page
>of the site will display large amounts of information extracted from an
>Oracle Database and formatted/distributed by servlets and JSPs. Anywhere
>from 15-20 different SQL queries should be able to gather the majority of
>the information that needs to be displayed on the front end.
>
>To avoid hammering the DB every time the results of a common query is needed
>(and to keep the number of db connections low), it would be nice to cache
>the common query results in an object or as class data for a number of
>objects. The object(s) would have to persist until the server was shutdown.
>Rare queries that do not match one of the standard 15-20 would warrant a
>connection to the db. Also, the cache object would need to be notified if
>any changes were made to the DB so that it could repopulate itself.
>
>Would a servlet be well equipped to act as an cache for db information, or
>is there another more standard means of doing this? Am I completely off
>track? Any advice would be greatly appreciated.
>
>Thanks
>brad
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
