Re: JT400/JDBC performance issues

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Mark,

On Wednesday 19 February 2003 02:23, you wrote:
> Suresh,
>
> To get performance that bad it seems like it would have to have something
> to do with the JDBC statements you are executing.  Are you using SQL Views
> in your SELECT?  Generally, these perform worse than Tables on the iSeries.

the diffrence is less than 0,1 sec

>
> You do not mention how large your tables are or how many records you are
> selecting.
>
> Finally, once those issues are worked out, a big area where problems will
> occur with the iSeries is if you do not use Connection Pools.  Establishing
> a connection to the iSeries has a high overhead.  Using a pool eliminates
> that problem.  However, we are talking seconds not minutes.

I've made measures on this, normally a connect shoul be < 0,3 sec and making 
800 connections to a little 270 should not be a problem. 
You should use connection pooling anyway, its easier to use for transaction 
handling and talking about web applications, you never know how many users 
wil connect, but in this case you won't see any improvement.

Dieter

>
> Hope this helps,
>
> Mark
>
>
> _______________________________________________
> 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