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
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)
Joined: Sep 05, 2001
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 ]