Re: database access - performance

["Dave Wall" <dawall@xxxxxxxxxx>]

For what it is worth I would use JDBC.
   The performance difference is not as big as it used to be.
   Work is on going on both the client and server side to make it faster.
   Little effort is going toward RLA.
   JDBC/SQL is a standard so what you learn you can apply to other
   platforms.

It is easier to write bad SQL code but with some experience you can make
your SQL implementation almost as fast as RLA.

David Wall
553-5329
AS/400 Toolbox for Java




                      Michael Knezevic
                      <m.knezevic@porta        To:       "Java/400 (E-Mail)" 
<java400-l@midrange.com>
                      .de>                     cc:
                      Sent by:                 Subject:  database access - 
performance
                      java400-l-admin@m
                      idrange.com


                      01/17/02 10:01 AM
                      Please respond to
                      java400-l





hello,

i try myself on my first real programm for the as400. now i'm thinking
about how to best access the files. what method has the best performance:

record-level-access
or
jdbc (data access through resultset)?

thanx
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.