Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is Oracle slower than sql server
faisal.mansoor_at_gmail.com wrote:
> Hello All
>
> I am having problem with oracle performance in comparsion with SQL
> Server. My application supports both Oracle (9.2) and SQL server (2000)
> database. I have identical schemas installed on both Oracle (installed
> on windows box) and SQL server, all the tables and stored procs are
> identical but I am constantly getting performace problems with oracle.
> Oracle takes twice or more time to perform the same data retrival and
> insertion tasks that SQL server does in half the time. Is it a general
> problem which every one faces? if not then please let me know how can I
> improve performance of on oracle database-- I am not comparing two
> oracle's snapsots, but I want to improve oracle's performance to match
> with SQL server --. Our data base is of medium size and we are running
> both oracle and sql with alomost all default configurations.
>
> Any one having such experience or solution to problem please answer.
>
> Faisal
The reason Oracle is slower is you subscribe to the myth Oracle is
Sqlserver sold by a different vendor. It is not. The architecture is
completely different.
If you *ported* the sqlserver application *directly* without change to
sqlserver, yes, you will have a non-performant applicationi.
Sadly, there are complete armies of Oracle DBAs who do nothing but to
resolve the errors made by people like you.
I would buy any book on Oracle architecture or development written by
Tom Kyte and he will explain you why you are wrong. He will also
provide you with the tools to find out where you are wrong.
Furthermore the Oracle Concepts Manual, online at
http://tahiti.oracle.com, is a mandatory read. Likely, being
brainwashed by the Evil Empire, aka Microsoft, you didn't read
anything.
There is no such thing as a database independent app, and there will never be.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Jul 26 2006 - 05:17:10 CDT