Re: Oracle slower then SQL Server 6.5 problem

In article <8qu1hq$liv$1_at_spiney.sierra.com>,   "Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote:
> It's probably your ODBC driver that's the pig.
>
> In my testing, SQL server performed better than Oracle,
> both on the exact same machine (W2000 Server),
> when < 32million rows (single table).
> Above 32M, Oracle kicked butt.
>
> I use an Intersolv ODBC driver which is about 5 times faster
> than the <intersolv?> driver Oracle provides with their Client.

While it would certainly be a good idea to try the Intersolv driver to see whether it improved the performance, I'd be suprised if both the Oracle & Microsoft ODBC drivers took 30 seconds and the Intersolv driver took 1 or 2 seconds.

If it were a factor of 2 or 3, I'd be apt to believe it's purely a driver problem. If the Oracle & Microsoft drivers took significantly different lengths of time to run the query, I'd lean toward a piggish driver theory. A factor of 30 shared by both these drivers leads me to speculate that something else is going on.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

> Microsofts SQL server ODBC driver is very very fast with
> their database.
>
> <jocave_at_my-deja.com> wrote in message

 news:8qtovm$lgr$1_at_nnrp1.deja.com...
> > In article <budA5.71$Dr6.2641_at_nsw.nnrp.telstra.net>,
> > "Rondo" <ron_at_iesys.com.au> wrote:
> > > Hi,
> > >
> > > I have an application that displays data from an ODBC data source.
 For
 a
> > > given query
> > > it takes about 1 sec on SQLServer 6.5 on a 450MHz/128MB PC but it
 takes 30
> > > secs
> > > on a highly configured Oracle server. All the usual indexes have
 been
 set
> > > up. There are no
> > > joins.
> > >
> > > The application uses bulk record fetching. I've tried the Oracle
 and
 the
> > > Microsoft Oracle drivers - no diff.
> > >
> > > I tried modifying the query to return 7 times as much data -
 surprise

• it
  > > > still took 30 sec
  > > > on Oracle. The O/S is WinNT4.0 - don't know SP.
  > > >
  > > > I'm sure its just some configuration thing but what?
  > >
  > > - Can you give a little more information about what the query and
  > > application is doing? A basic outline of the ODBC calls it's making
  and
  > > what the SQL statement does would be useful.
  > >
  > > - Have you tried executing the same query in SQL*Plus? If so, did
  it go
  > > quickly?
  > >
  > > - Are you able to step through the application to see which ODBC
  > > statement is taking so long?
  > >
  > > Justin Cave
  > > ODBC Development
  > >
  > > Opinions expressed herein are my own and may not reflect those of
  Oracle
  > > Corporation.
  > >
  > >
  > > Sent via Deja.com http://www.deja.com/
  > > Before you buy.
  >
  >
  

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 28 2000 - 20:41:24 CDT