RE:SQL Insert

["Suresh Kumar" <suresh@xxxxxxxxxxxxxxxxxx>]

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