Re: ODBC performance on Unix?

From: Anthony Mandic <am_at_agd.nsw.gov.au>
Date: 1999/11/17
Message-ID: <38323F61.C63C55B4_at_agd.nsw.gov.au>#1/1


Alex Ratner wrote:

> I am pondering what way of database access to choose: ODBC driver for
> Unix or Oracle/Sybase native interface or, maybe, something else?
> Using ODBC allows me to keep the same source code, but then the
> performance, apparently, will be worse.
> The question is: how much worse is the ODBC performance on Unix vs.
> other options?

	It would be negligible. The extra layer of abstraction doesn't
	add too much overhead. And, as you say, it minimises the amount
	of coding changes required.

> Is the effort to change database access code worth the gains?

	Probably not to start with. Stay with ODBC until you have settled
	on your backend (this will allow you to change backends more
	easily until you can decide).

-am Received on Wed Nov 17 1999 - 00:00:00 CET

Original text of this message