Performance between JT400 and Client Acces ODBC -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Performance between JT400 and Client Acces ODBC
From: "Franco Biaggi" <fbiaggi@xxxxxxxxxx>
Date: Tue, 28 Nov 2000 11:05:40 +0100

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.

Franco Biaggi
SISA Studio Informatica SA
R&D Services
Via Carvina 1
CH-6807 Taverne
Tel. +41 91 935 75 35 Fax. +41 91 935 75 30
ICQ:59714125(disabled)

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.