|
midrange.com
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.
