Kevin & Julian
Would put the data in a database effectively reduce the overhead.
For example if the JSP is written to do
SELECT cl_company_name FROM company_list
Say
CREATE TABLE cl_company_name (
cl_id integer,
cl_company_name varchar(100),
cl_street varchar(64),
cl_city varchar(64),
cl_state varchar(64),
...
)
It you had a million hits aday doing the same SQL request over and over
you are hoping that the RDBM is caching the table "company_list".
If the `company_list' never changes then it would be fine.
Would it make sense to write cached or leased time Vector object?
But if we wont another JSP that allow admin to update to delete
rowsets from `company_list' then we have problems.
I think we trading off speed and efficiency and update-ability?
Can any DBA give a view of performance of RDBMS with such JSP
request on caching or non-caching this everyday time of query?
--
Peter Pilgrim
G.O.A.T
"the Greatest Of All Time"
---------------------------------------- Message History
----------------------------------------
From: Kevin Jones <[EMAIL PROTECTED]>@java.sun.com> on 18/01/2001 21:02
Please respond to A mailing list about Java Server Pages specification and reference
<[EMAIL PROTECTED]>
DELEGATED - Sent by: A mailing list about Java Server Pages specification and
[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: MVC Architecture and JSP
How long should the data last?
Is it used only by one user or multiple users?
Could you put it into a database?
Kevin Jones
DevelopMentor
www.develop.com
> -----Original Message-----
> [mailto:[EMAIL PROTECTED]]On Behalf Of julian sitkewich
--<CUT>--
>
>
> I pose a question, in the MVC (Model-View-Controller) architecture
> information is commonly passed between servlet and JSP via session. This
> seems to go against certain principles of server overhead and memory
> consumption. My example is this: A servlet creates a HUGE Vector
> object of a
> company department directory list. The request is forwarded to the JSP to
> list the contents of the Vector. Is there a better way than to store my
> large Vector in the user Session??
>
--<CUT>--
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
