Re: Oracle slower then SQL Server 6.5 problem

From: <jocave_at_my-deja.com>
Date: Wed, 27 Sep 2000 21:31:33 GMT
Message-ID: <8qtovm$lgr$1@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. Received on Wed Sep 27 2000 - 16:31:33 CDT