RE: JT400/JDBC performance issues

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Suresh kumar BV
>
> What could be the problems?? Do we need to implement some other LIC PGM on
> AS400 to make this run faster?? Can we debug this to see where exactly it
> is slowing down? Are there any joblogs in AS400 which will give
> clues as to
> why it is slow? Any suggestions on this is most welcome,

Start please by determining exactly where the bottleneck occurs.  Is it the
servlet or the JDBC driver?  To do this, I suggest writing a standalone Java
program on your PC that performs the exact JDBC operations that your servlet
does, and then telling us the results.  No calculations on the results, no
manipulation of the data, simply fetching the data using simple JDBC.

I have run many such applications and accessing data from four small files
has never taken 20 minutes.  So, let's break your application down and find
out where it is failing.  It is possible that you are running into security
or object locking problems.

Joe