Re: Oracle slower then SQL Server 6.5 problem

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.

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.