Re: Speed question?

[Jim Mason <jmason900@xxxxxxxxx>]

Hi.

Db2 access using standard sql with JDBC seems to work
very well in all circumstances I've used it.  The key
is reusing JDBC resources, connections, statements
etc.  WebSphere allows pooled data sources that make
this efficient but you can do it yourself...

Jim Mason

--- Robert Upshall <rupshall@psasoft.com> wrote:
> Hi,
>
> I have a question.  I have a swing application that
> uses JTOpen classes to
> access DB2 files and to make pgm calls.  My
> problem/concern is file access
> is so much slower that a pgm call, i.e. if I open a
> DB2 file in java and
> read a  record it takes noticeably longer than if I
> was to call a RPG pgm to
> read the same record and return the record as
> parameters.  The file.open()
> method appears to be the place I get the biggest
> speed hit.  Is there any
> tweaking that I can do client and/or server side to
> speed this access?
>
> Anybody have any suggestions?
>
> Robert Upshall
> Professional Software of Amarillo
> (806) 358-8928
> rupshall@psasoft.com
>
>
> _______________________________________________
> 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.
>


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/