Archives of the TeradataForum

Message Posted: Tue, 21 Jan 2003 @ 17:27:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

To help decide which client to make use of for various future projects, I decided to run a series of tests.

The test basically measured the execution of a query, and the return of 246,971 rows into a list held within memory (except for FastExport which output to a file). I ran each test three times, and took the average performance, to ensure the current load of our Teradata system did not affect the figures to much.

Based on this test, I have compiled the following table, in order of performance.

1.    10 seconds              FastExport v7.06.01.00

2.    15.693 seconds          BEA JRockit 8.0 - JDBC Type 4 Driver
                              from Chuck McDevitt

3.    18.086 seconds          Borland Delphi Executable - ODBC
                              3.01.0.0 - Direct Calls

4.    22.067 seconds          BEA JRockit 8.0 - JDBC Type 2 Driver
                              from Teradata

5.    22.386 seconds          Borland Delphi Executable - NCR OLE
                              DB Provider - Direct Calls

6.    22.403 seconds          Sun JDK 1.4.1_01 - JDBC Type 4
                              Driver from Chuck McDevitt

7.    23.411 seconds          Sun JDK 1.4.1_01 - JDBC Type 2
                              Driver from Teradata

8.    23.701 seconds          Sun JDK 1.3.1_01 - JDBC Type 4
                              Driver from Chuck McDevitt

9.    23.747 seconds          Borland Delphi Executable - OLE DB
                              to ODBC Bridge - Provided ADO
                              Components

10.   24.699 seconds          Borland Delphi Executable - NCR OLE
                              DB Provider - Provided ADO
                              Components

11.   24.89 seconds           Atanasoft AtanSuite 2002 - Microsoft
                              .NET, CLI Interface

12.   1 minute 53 seconds     QueryMan v6.0

All tests were run under a Windows 2000 SP3 Desktop PC, Pentium 4 1.5GHz, with 512MB Memory.

Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional

	<Prev	Next>		<<First	<Prev	Next>	Last>>