|
midrange.com
I'm sorry, my last piece of advice wasn't quite right. You need to do a
couple things to turn on extended dynamic. You need to set it to true, set
a package and (optionally) set a package library. The code I used was
String connect_string = "jdbc:as400://myAS400/dawstuff;" +
"naming=sql;" +
"errors=full;" +
"user=myUid;" +
"extended dynamic=true;" +
"package=dawpkg;" +
"package library=dawstuff;" +
"password=myPwd" ;
I have less confidence now that it will help you, however. What
extended-dynamic does is save a parsed/compiled version of the sql
statement in the package/package library. Performance is helped if
statements are repeated because the system can use the pre-compiled version
of the statement. It also looks like it takes are relatively complex
statement to improve performance. I did a simple "Select * from QCUSTCDT"
and didn't see any difference. Please give it a try in your environment
anyway and let us know how it turns out.
David Wall
553-5329
AS/400 Toolbox for Java
---------------------- Forwarded by Dave Wall/Rochester/IBM on 11/30/2000
03:50 PM ---------------------------
"Franco Biaggi" <fbiaggi@ticino.com> on 11/30/2000 09:45:50 AM
Please respond to "Franco Biaggi" <fbiaggi@ticino.com>
To: Dave Wall/Rochester/IBM@IBMUS, "JAVA400-L@midrange.com"
<JAVA400-L@midrange.com>
cc:
Subject: Re: Performance between JT400 and Client Acces ODBC
David,
exaclty the same performance using dynamic=true
On Tue, 28 Nov 2000 12:55:16 -0600, Dave Wall wrote:
>
>The property is extended dynamic=true
>
>David Wall
>AS/400 Toolbox for Java
>
>
>Jerrold_Bisera@countrywide.com@midrange.com on 11/28/2000 11:59:06 AM
>
>Please respond to JAVA400-L@midrange.com
>
>Sent by: owner-java400-l@midrange.com
>
>
>To: JAVA400-L@midrange.com
>cc:
>Subject: Re: Performance between JT400 and Client Acces ODBC
>
>
>
>
>What would the extra configuration be to make use of the package support
>(aka extended dynamic) for the JT400 toolbox driver
>
>
>
>
>
>"Richard Dettinger" <cujo@us.ibm.com>@midrange.com on 11/28/2000 08:38:31
>AM
>
>Please respond to JAVA400-L@midrange.com
>
>Sent by: owner-java400-l@midrange.com
>
>
>To: JAVA400-L@midrange.com
>cc:
>
>Subject: Re: Performance between JT400 and Client Acces ODBC
>
>
>
>I posed your question to one of our performance guys and got this back:
>
>I don't understand why Create and Drop Table are both faster, but I would
>expect the others to be faster by default (no tuning). The main reason
is
>that ODBC uses package support (aka extended dynamic by default and the
>Java toolbox driver requires extra configuration to make use of that
>function. When I was testing ODBC I would normally see a 50% to 2X
>improvement in throughput with package support.
>
>
>Regards,
>
>Richard D. Dettinger
>AS/400 Java Data Access Team
>
>"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
>WILL you say that I am mad?
>The disease had sharpened my senses, not destroyed, not dulled them. "
>
>- Edgar Allan Poe
>"The Tell-Tale Heart"
>
>
>
>
>"Franco Biaggi" <fbiaggi@ticino.com>@midrange.com on 11/28/2000 04:05:40
AM
>
>Please respond to JAVA400-L@midrange.com
>
>Sent by: owner-java400-l@midrange.com
>
>
>To: "JAVA400-L@midrange.com" <JAVA400-L@midrange.com>
>cc:
>Subject: Performance between JT400 and Client Acces ODBC
>
>
>
>Hello,
>we are made some performance test from a client to the AS/400.
>1.st using the JT400 JDBC driver.
>2.nd using SUN JDBCODBC driver over ClientAcces ODBC
>
>There are very big differences:
>(Times in milliseconds)
>
>ODBC JT400
>
>Create table: 1302 1562
>Insert 1000 rows: 15643 29142
>Read 1000 rows: 24185 33919
>Update 1000 rows: 16664 27679
>Delete 1000 rows: 16563 27260
>Drop table: 771 861
>------------------------------------
>Total: 75158 120243
>------------------------------------
>
>The SUN driver combined with CA ODBC produce very better performance.
>
>Any comment aprreciated.
>Thanks.
>
>
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---
>
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---
>
>
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---
>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>
<body>
<p> </p>
<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
<tr>
<td width="446"><font face="Comic Sans MS"><small><small><br>
<font color="#3333FF"><a href
="http://www.ticino.com/usr/fbiaggi/">Franco Biaggi</a></font><small><br>
<font color="#3333FF"><a href="http://www.sisa.ch">SISA Studio
Informatica SA</a></font><small><small><small> <br>
</small></small></small><font color="#3333FF">R&D
Services</font><small><small><small>
<br>
</small></small></small><font color="#3333FF">Via Carvina
1</font><small><small><small> <br>
</small></small></small><font color="#3333FF">CH-6807
Taverne</font><small><small><small> <br>
</small></small></small><font color="#3333FF">Tel. +41 91 935 75
35 Fax. +41 91 935
75 30</font></small></small></small><br>
</small></small></small><font color="
#3333FF">ICQ:59714125(disabled)</font><small><small><small> <br>
</font></td>
</tr>
</table>
</body>
</html>
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
