Re: SQL insert

Hi,

how many records do you retrieve in this 20 seconds??? 10 (to slow for every 
constellation), 100 (maybe to slow, depends on Hardware)  or 1000 (worka as 
designed, might be better with lots of balanced Hardware).
Give us more input to assist in your problem.

Dieter
 

On Wednesday 26 March 2003 12:50, you wrote:
> Hi all,
>   First of all, couple of weeks ago, I had posed a question regarding the
> slowness of AS400 data access thru JT400. Thanx for all the help, we
> brought down the response time from 15-20 minutes to about 20 seconds now.
> Just to summarize (might help somebody),  we implemented the following 
> steps:
>
> 1. Client PC running Web Server is on the same LAN as AS400 (before the web
> server was accessing AS400 data remotely). 2. Appserver with connection
> pooling (this seems to have cut down the response time by half). 3. Stored
> procedures: this did not improve response time time dramatically (about
> 10-15%). I was expecting 50% improvement. 4. Remove DOM structures within
> the Java. We are now going with Hash table concept.(this has definitely
> increased the speed by atleast 50%) 5. Preparestatements wherever
> necessary.
>
>  Couple of observations:
> 1. Even with all these steps, response time of 20 seconds is not
> acceptable. We are continuing to improve the code. We do have about 20 SQL
> statements to get data from various tables (all tables are small) and then
> the HTML is created and sent to client. Is 20 seconds response acceptable??
>
> 2. New problem: when we try to insert data into one of the AS400 table, we
> get an error SQL7008 (<file> in <library> not valid for operation). It
> looks like the system is expectng for us to journal the table. Howevere,
> this table is not journalled even in our main AS400 application. At the
> same time, when this SQL statement is executed using CA400, there is no
> error and record gets inserted into that table. We don't do journalling at
> all on this table anywhere. Is there any parameter that needs to be
> specified when the connection is first established??
>
> 3. The same setup with Oracle as back end seems to run much faster (within
> 5 seconds). Is this generally true??
>
> Thanx for all the help,
> 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