RE: database access - performance

["Patrick L Archibald" <Patrick.Archibald@xxxxxxxxxxxxx>]

I haven't run any comparisons but with statement pooling
and connection pooling available now on the iSeries, JDBC
performance is probably closing in on record level
access.  I chose JDBC.

My .02 worth, PLA


-----Original Message-----
From: java400-l-admin@midrange.com
[mailto:java400-l-admin@midrange.com]On Behalf Of Michael Knezevic
Sent: Thursday, January 17, 2002 11:20 AM
To: 'java400-lmidrangecom'
Subject: RE: database access - performance


this one is specific for the iSereis.
thanx for the advice.

-----Original Message-----
From:   Duane Kehoe [SMTP:dkehoe@weycogroup.com]
Sent:   Thursday, January 17, 2002 3:12 PM
To:     java400-l@midrange.com
Subject:        RE: database access - performance

Record Level access is much better from a performance standpoint but not
from a portability standpoint.  Recordlevel access is designed specifically
to make java programs work very well with the iSeries where as jdbc is
designed to make java work generally with any database at a
performance/speed cost.

______________________________________________________________

Duane Kehoe                      phone:  414.908.1814
Programmer / Analyst             fax:  414.908.1601
Weyco Group, Inc.                email:  dkehoe@weycogroup.com


-----Original Message-----
From: java400-l-admin@midrange.com
[mailto:java400-l-admin@midrange.com]On Behalf Of Michael Knezevic
Sent: Thursday, January 17, 2002 10:02 AM
To: Java/400 (E-Mail)
Subject: database access - performance


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.

_______________________________________________
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.
_______________________________________________
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.