Archives of the TeradataForum

Message Posted: Mon, 17 Jan 2005 @ 18:19:53 GMT


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

Subj:		Re: JDBC vs. OLE DB

From:		Matthew Winter

Hi,

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.

Regards

Matthew Winter