File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Performance and the fly likes Web App on iPlanet Web Server & Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Web App on iPlanet Web Server & Oracle" Watch "Web App on iPlanet Web Server & Oracle" New topic

Web App on iPlanet Web Server & Oracle

Shailesh Nakhare

Joined: Aug 29, 2001
Posts: 4
Hi All,
I have the following situation in development and am facing the problem mentioned here :
1. There is a Web Based Application developed in JSPs, Servlets and Beans (not Java Beans or EJBs but simple java classes used to access data from the DB and updating the same to the DB).
2. All the above mentioned sources run in an iPlanet Web Server 6.0 container.
3. The JSPs are used for Viewing, Adding, Editing data from an Oracle 8.x database on some other machine and this is done thru Beans (as mentioned above).
4. All the requests to the various JSPs are routed thru a RouterServlet which calls the appropriate JSP for the functionality.
5. This configuration works fine with some lesser number of users accessing the web site. But, when the Number of users accessing the system increases, the performance of the system reduces drastically. Thus the web page (JSP) being accessed takes around 500% more time than accessing it normally !
6. We have not been able to pin point the problem as yet, but think that the problem may actually be :

a. The "Web Server" not being able to serve multiple requests at a rapid pace.
b. The "Database" may not be able to perform fast fetches / updates to the data, being requested / updated by the Beans.

Has anyone faced similar situation earlier or could you suggest some solutuion for the same ?
Also, can anyone tell me about simulating the scenerio of a Web Browser accessing a JSP page, by using some simple java application / class.
Pls. let me know of any possible solutions !
Thanks in advance..... !
- Shailesh
Jun Hong
Ranch Hand

Joined: Sep 05, 2001
Posts: 181
The performance issue may be related to database. Do you have a connection pool for the database base.

Jun Hong<br />SCJP, SCJD, SCWCD, SCEA<br />IBM Certified Systems Expert(V4.0)
Jun Hong
Ranch Hand

Joined: Sep 05, 2001
Posts: 181
By the way the performance of fetch could be improved by setting a larger fetch size. Also, the update can be batched. Anyway, this will affect the performance of each request.
[ January 25, 2002: Message edited by: Jun Hong ]
Adam Adams
Ranch Hand

Joined: Nov 28, 2001
Posts: 60
is the routerServlet playing the role of a proxy and has the capability of load balancing?
check this out also, if you share your code it might be very helpfull ..
I agree. Here's the link:
subject: Web App on iPlanet Web Server & Oracle
It's not a secret anymore!