Archives of the TeradataForum
Message Posted: Mon, 17 Jan 2005 @ 18:19:53 GMT
My belief is that they are all as good as each other, and essentially it comes down to the skillset of your developers and the platform you intend to run this on.
Optimisations can be done for both to improve performance, with majority of these being on the database/sql rather than at the client level.
My only recommendation would be that you make use of the Type 4 driver if you want to go with the JDBC approach.
I did some straight performance tests a long time ago, where I returned a large dataset for processing on the client. The order of performance was as follows, with 1 being the highest.
1. Native CLI
2. CLI# wrapper of the Native CLI
3. Atanasoft ADO.NET Provider
4. Type 4 JDBC Driver
5. ODBC Driver
6. OLE DB Driver
The biggest shift in performance was between 3 & 4.
However if your datasets are small and the queries are optimised (i.e. Single AMP access), then the differences are negligable, as majority of the time difference comes from handling of the returned data.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|