Archives of the TeradataForum
Message Posted: Tue, 21 Jan 2003 @ 17:27:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|