Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Perfomance differences with big databases and Unix systems
> 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