Re: JDBC and SQL Performance Under V5R3

Ed,

what sort of stuff are they doing with the java? Its difficult to see where
the performance issues are without more details?

For very large volumes of data, they should be using the fastest thing
possible. For database access, that is going to be well designed RPG
programs.

cheers
Colin.W

----- Original Message ----- 
From: "EDoxtator" <doc6502@xxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, November 03, 2004 3:24 PM
Subject: JDBC and SQL Performance Under V5R3


> All
>
> I'm working at a client right now who is using OS/400 V5R1 and client has
> written a series of Java (JDK 1.4) with WSDS, and is seeing some fairly
awful
> performance issues.
>
> I've suggested some things (limiting the use of the like keyword, using
> existing logical file access paths, etc), but they've got a huge amount of
data
> (2 TB) to sift through.
>
> >From what I have read from IBM, there are significant gains to be made in
> overall SQL performance in V5R3.
>
> Are these claims valid?  Has anyone been using V5R3?
>
> Thanks
>
> -Ed
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.