Re: Oracle vs SQL Server

From: James Knowles <kaa_at_xmission.com>
Date: Sun, 06 Jun 1999 02:41:55 +0000
Message-ID: <3759DFF3.C47D3087@xmission.com>

> I've always heard that SQL Server could not match Oracle's stability or
> power for large database systems. SQL Server is good for smaller databases
> and it's easy to use. Oracle is more complex, but lets you have more users
> connected and performs much better.

This is a good summary of my experiences. I have to rewrite some software because SQL server's performance fell through the floor as the number of rows passed 1,000,000 in one simple table. Only single excact matches against the primary key are responsive anymore. Everything else comes back in 30-45 minutes.

No joy.

I've also worked on an Oracle system that had nearly 7M rows distributed between 4 tables. Lots of complicated joins were happening constantly. The contrast was rather staggering.

Yes, there are a *lot* of variables; these have just been my experiences.

--
It's coming... http://www.countdown9199.com Received on Sat Jun 05 1999 - 21:41:55 CDT