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

Home -> Community -> Usenet -> c.d.o.server -> Is Oracle slower than sql server

Is Oracle slower than sql server

From: <faisal.mansoor_at_gmail.com>
Date: 26 Jul 2006 02:57:24 -0700
Message-ID: <1153907843.975190.183460@p79g2000cwp.googlegroups.com>


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 Received on Wed Jul 26 2006 - 04:57:24 CDT

Original text of this message

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