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
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