It's seem pretty good, but my question is
do you have database connection pool between your sqlclass and db?
>From my testing, I found the database connection initialize cost a lot
of performance to my system.
Right now, I'm using JRun (it provide dabase connecion pooling function)
with Oracle.
A.Somsak
Rathinavel Palaniappan wrote:
>
> Hi all,
>
> I have a question regarding the architecture to follow in the
> web
> applications. our application is going to be on the net and
> the
> number of users will be 20 to 30 at a time.we plan to use
> JSP and Bean and the flow we thought is something as
> below.
>
> jsp -> bean -> businessObject -> sqlclass -> DB
>
> FYI, we will be having number of beans,businessClasses and
> sql classes.All the parameters will be passed as object
> (dataObject) from bean to sqlclass.There will be 'n' number
> of dataObject equivalent to the tables in the DB.
>
> we are worrying about the performance because of the net
> slow in some countries.
>
> my question here is that does this architecture(having 5
> logical
> layers) will make the process slow? if so what can be the
> best
> application architecture for this scenario?
>
> I have an another question regarding populating the values
> from db
> to the screen.for example i have to show some values in the
> list,
> should i have to fetch each and every time whenever the page
> is loaded?
> or keep it in the session scope and show it ?
>
> If i keep it in the session , how do i get the latest value
> if it is updated
> in the DB through some other user?
>
> Thanks for your time,
>
> with regards,
> rathna.
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
