Re: ORACLE 8.0.3.0.0 is extremely slow vs SQL7 for medium database

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 24 Mar 1999 03:55:10 GMT
Message-ID: <7d9nmr$6br$1@nnrp1.dejanews.com>

In article <7d8ltt$j3d_at_bgtnsc03.worldnet.att.net>, "Patrick Nance" <pnance_at_colonialDESPAMOtech.com> wrote:
> Try using the Microsoft Oracle Driver. I have found that the MS driver is
> MUCH faster on Oracle than the Oracle driver.
>
> Julian Cowking wrote in message <7d8l2j$m9n$1_at_starburst.uk.insnet.net>...
> >I am writing an app which I need to work with both SQL server 7 and Oracle
> >8x
> >
> >Here are my problems...
> >
> >1) with small databases things are very comparible between the two. However
> >when using a medium database (100,000 employees, say) Oracle begins to
> >perform very poorly in comparison with SQLServer 7. Now, I thought that
> >Oracle was supposed to come into its own with larger databases. I am a
> >complete newbie to Oracle so, I imagine that I must start some tweeking to
> >get things really flying.
>
>

Try using 8.0.5. Oracle 8.0.3 is an ancient version (the 1st production version) and has been improved upon quite a bit. Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 23 1999 - 21:55:10 CST