Re: Initial JDBC Hits to AS/400 DB using Tomcat is Very Slow?

    Although it takes more effort and setup, you can also precompile your
JSPs and avoid the hit.  See

http://ant.apache.org/manual/OptionalTasks/jspc.html

and search on jspc and Jasper along with Tomcat for more information.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO         -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?             http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Mike Silvers" <msilvers@xxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, December 16, 2003 9:44 AM
Subject: Re: Initial JDBC Hits to AS/400 DB using Tomcat is Very Slow?


> Every time you start the Tomcat server, the temporary class files created
> from the jsp's are created (when the page is first hit).  This is what
> causes the slow response from the first hit.  You have a couple of
options.
> You could not shutdown the iSeries nightly (I believe that IBM does not
> recommend shutting down the iSeries daily).  Another thing you could do is
> to write a program that hits the page in question after the iSeries comes
up
> (so the users would not see the slow response).  Any platform running
Tomcat
> in this same scenario (shutting the server down daily) would have this
same
> issue.
>
> Mike
>
>
> ----- Original Message -----
> From: "cornelius, chad" <chad.cornelius@xxxxxxxxxxxxxxxxxxxx>
> To: <JAVA400-L@xxxxxxxxxxxx>
> Sent: Tuesday, December 16, 2003 9:19 AM
> Subject: Initial JDBC Hits to AS/400 DB using Tomcat is Very Slow?
>
>
> > Does anyone know what would cause initial JDBC hits on an AS/400 DB to
> > perform slowly using Tomcat?  I have setup Tomcat to use connection
> pooling
> > just as David suggests in his article, "Tomcat on iSeries", which is
very
> > good by the way.  I have compiled all the .jar files, but Tomcat still
> > performs slowly on the first hits.  Our AS/400's shutdown nightly to
> perform
> > backups, so I am not sure if this is the cause.  After one hit is made
to
> a
> > table, all other hits are very fast.  It's just the first hit in the
> > morning.  My other thought is that we do not have the SQL package on our
> > AS/400, which allows you to perform the STRSQL command.  Would this be
> > another reason?  It seems JDBC would be independent of that.  Does
anyone
> > have any suggestions?  Any help would be greatly appreciated.
> >
> >
> >
> > Thanks,
> >
> > Chad
> >