Re: SQL Insert

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

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