Re: SQL Insert

HI Dieter,
  I am surprised to see the kind of performance you are getting out of your
AS400 box.  Are u running the app natively on AS400? In our case, we are
usng JT400 for DB access and the java servlets run on a PC server under IBM
WAS 4.0 app server. Both PC server and AS400 are on the TCP/IP LAN network
wth the speed 10/100 MBPS. Also, the AS400 is pretty high end (9406-720)
runnng V4R4 and is about 45% utilized. Plenty of disk space (80GB), memory
(2GB) and processor speed available.

 Do you think network config and/or JT400 is givign raise to this kind of
poor performance??

Suresh

----- Original Message -----
From: "Dieter Bender" <Dieter.Bender@xxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Thursday, March 27, 2003 2:46 PM
Subject: Re: SQL Insert


> Hi Suresh,
>
> that seems quite a lot for me. On my little 170 it takes about 8 seconds
to
> connect to the database and poll 10.000 records into a swing TableModel
> without any performance tuning, using plain JDBC or even SQLJ. Using a
real
> databasee Server, this should be finished in 1 or 2 seconds, or even less.
> you should not invest your time in finding work arounds (stored
procedures,
> record level access, ...) first thing should be to find the reason for the
> problem. what is the system doing all the time and wich component causes
the
> problem.
> Did you have a look with the Database Monitor to find out how long every
> request (Connect, open cursors, fetching records) to the database took???
> Did you have a look to the overall workload (CPU, memory, disk activity,
> network traffic) of the system with management central to find the
> bottleneck???
>
> Dieter
>
> On Thursday 27 March 2003 06:53, you wrote:
> > Hi Dieter,
> >   This is the statistics:
> > 1. We do about 25 SQL statements against 4 tables.
> >
> > 2. All the tables are small (about 100 records/table) except one which
has
> > about 10,000 records.
> >
> > 3. Ultimately we end up getting about 60-70 records from these tables
which
> > is needed for processing by the servlet (at the App server).
> >
> > 4. I have 2 questions in connection with this:
> >    a. In the stored procedure (written in RPGLE), we are basically
> > peforming various SQLs and returning the result set cursor back to the
Java
> > client program. This RPG program declares the cursors (SQLs), open the
> > cursors and return them: all together about 15 result sets. Other option
is
> > to call the RPG program repeatedly so that it will send back proper
cursor
> > one at a time. Which will be faster??
> >
> >    b. Also, is it faster with array result sets as opposed to cursor
result
> > sets?? How can the client read an array result set in the Java servlet?
> >
> > Suresh
> > Antares Systems Ltd.
> > # 24, Sudha Complex, 3rd Stage, 4th Block,
> > Basaveshwaranagar,
> > Bangalore - 560 079
> > Telefax : 91-80-3284311, 3284313
> > _______________________________________________
> > 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.
>
> --
> mfG
>
> Dieter Bender
>
>
> DV-Beratung Dieter Bender
> Wetzlarerstr. 25
> 35435 Wettenberg
> Tel. +49 641 9805855
> Fax +49 641 9805856
> www.bender-dv.de
> _______________________________________________
> 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.
>

Antares Systems Ltd.
# 24, Sudha Complex, 3rd Stage, 4th Block,
Basaveshwaranagar,
Bangalore - 560 079
Telefax : 91-80-3284311, 3284313