Re: Oracle slower then SQL Server 6.5 problem

This is contrary to my experience. When Oracle is properly configured, it will outperform SQL Server on the same hardware (and OS), irrespective of the number or rows in the table.

Run an explain plan on the statements and make sure that indexes are being used as expected. I'll bet you find one or more table scans.

--
Michael D. Long
http://extremedna.homestead.com


"Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote in message
news:8qu1hq$liv$1_at_spiney.sierra.com...


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

>

>