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
hi, The problem can be traced very easily useing profiler tool such has optimizeit which you can get demo version 15 days trail at www.vmgear.com. The possible cause i can think of from the information you have provided is, Lot's of objects might been created which might be optimized by code review. Apart from that you have to distubite the load by looking the architechire/design of your site. Also fine tuning of server (web server and oracle server) need to be done. For the same both iplanet and oracle gives user manual to achive the same. Hope this information helps -arun
Sharing is learning
subject: Web App in JSP , Servlets, Oracle on iPlanet web server