Oracle slower then SQL Server 6.5 problem

From: Rondo <ron_at_iesys.com.au>
Date: Wed, 27 Sep 2000 14:08:18 +1000
Message-ID: <budA5.71$Dr6.2641@nsw.nnrp.telstra.net>

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?

Cheers,
Ron

PS - please email me Received on Tue Sep 26 2000 - 23:08:18 CDT