Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Perfomance differences with big databases and Unix systems

Re: Perfomance differences with big databases and Unix systems

From: AK <ak_tiredofspam_at_yahoo.com>
Date: 28 Nov 2004 20:50:59 -0800
Message-ID: <46e627da.0411282050.60cb7817@posting.google.com>


> is it really going to be a difference between running our database with
> Microsoft SQL Server and Windows
> than running on a Unix system with Oracle, for example?
>

in my experience the main difference would be dramatically better robustness, concurrency and security of Oracle running on a Unix box. Performancewise, it kinda depends.

For instance, inserting from one thread into a flat file, such as a *.dbf, will outperform inserting into both Oracle and MS SQL Server any time of the day, and the reason is simple: you don't have any overhead of maitaining recoverability / security / concurrency etc.

So, if performance of inserts is your top priority, go for a flat file! Received on Sun Nov 28 2004 - 22:50:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US