Re: Performance on NT: Oracle vs. SQLServer?

doug a blaisdell (dougb_at_world.std.com) wrote:
: Hi out there!
:
: We're trying to decide between Oracle and SQL server, for a DSS database with
: about 200 Meg of data now, but much larger soon (eg 1 Gig). We've got a dual
: processor with 128 Meg (but could increase this), running NT 4.0.
:
: I've heard that Oracle doesn't run as fast on NT, as on UNIX. Have any of you
: had experience with either/both, or know of performance benchmarks of Oracle
: vs. NT??

I don't have experience with Oracle vs. SQL Server performance-wise. However, I can tell you that SQL Server does not support some of the basic elements of the ANSI standard such as cascading deletes/updates, nor does it support before/after triggers. SQL Server also has quite a few annoying bugs that impede the development cycle.

-- 
sja.                                             Visit Mitel at:
Stephen_Anderson_at_Mitel.COM                       http://www.mitel.com
(613) 592-5660x1651                              Web with attitude.