Thanks again. I have connection pooling which works fine. Also I have created SQLPackages and data compression to true.
Hari -----Original Message----- From: Reynir Hübner [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:40 PM To: Tomcat Users List Subject: RE: Precompiling JSP Hi again, Few tips : Use connection pooling, cache data from database if you can, lazyload data from database when that is a good idea etc. Creating connections to DB2 is not the fastest thing around, so I suspect connection pooling may take 2 seconds of that time. Hope it helps -reynir > -----Original Message----- > From: Hari Venkatesan [mailto:[EMAIL PROTECTED]] > Sent: 13. janúar 2003 13:48 > To: Tomcat Users List > Subject: RE: Precompiling JSP > > > Thanks Reynir, > > This was exactly I was looking for. Our Jsp's are loading > very slow. We are using JDBC connection to DB2/400 and our > initial database has only about 100000 records. It takes > about 7 - 10 seconds for our JSP's to load. > > Hari > > -----Original Message----- > From: Reynir Hübner [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 8:28 AM > To: Tomcat Users List > Subject: RE: Precompiling JSP > > Hi, > > In my understanding it really only affects performance. > > The first request on a jsp always takes longer to execute > because at that time it must precompile the jsp. > If you run a precompiler (such as jspc) on the jsp pages > before you start up the server (or at startup) you will > shorten the time of response on the first request of a jsp page. > > If you are dealing with performance there are many other > things that you might want to look at. > I recommend the following page as a good material on this matter: > http://www.javaperformancetuning.com/ > > Hope it helps > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: Hari Venkatesan [mailto:[EMAIL PROTECTED]] > > Sent: 13. janúar 2003 13:23 > > To: [EMAIL PROTECTED] > > Subject: Precompiling JSP > > > > > > Is there any definitive advantage of precompiling JSPs' when > > tomcat server starts UP. Does this have any effect on performance? > > > > Hari > > > > -- > To unsubscribe, e-mail: > <mailto:tomcat-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:tomcat-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>