Oracle vs Sql Server

Posts   
 
    
ChBaeumer
User
Posts: 175
Joined: 23-Oct-2003
# Posted on: 08-Mar-2006 17:01:13   

Hi!

I'm just playing around. We have a software which currently uses the SQL Server from MS to store data. In the future we like to support other databases, too.

One of the other dbs will be Oracle, of course.

I use following DBs: MSDE 2000 SP4 and Oracle XE I wrote a schema for both dbs and generated the LLBLGen Pro projects.

Since our software relies on Guids as PKs, I wrote an TypeConverter to map the Guid to the used db type.

I tried following types in the Oracle db as Guid: - raw - nvarchar2(36) (I used this in the Sql Server, too) - char(32) (I used this in the Sql Server, too)

Raw was the worst solution. I inserted 100.000 rows in both dbs and executed following statement on both dbs:


delete from element

Oracle needed for this small script nearly 6 minutes(!) to execute whereas the SQL server needed just a few seconds.

Representing the Guid as nvarchar2 or char cut down the time but Oracle is far slower than the Sql Server.

So, my question is, how could I speed up the access to the Oracle db? Has someone run into the some problems or discovered the some thing?

Curious

Christoph

alexdresko
User
Posts: 336
Joined: 08-Jun-2004
# Posted on: 08-Mar-2006 17:27:29   

This won't help you a bit, but I had about an hour long conversation with an Oracle junkie ni CompUSA over the weekend. He was quite certain Oracle was faster than SQL in most cases. simple_smile

ChBaeumer
User
Posts: 175
Joined: 23-Oct-2003
# Posted on: 08-Mar-2006 17:46:02   

Great wink I guess running the Oracle DB on an unix server with raw partitions will beat the SQL server. But we just use the db for the persistance of the data from our software.

I think that it doesn't really matter in our case if one db is faster than the other since just small amounts of data is inserted/deleted/updated. But in this case the SQL server is up to 10 times faster (I have to admit I didn't really examined this enough)

The only heavy operation we have is to dump and restore the whole db. With the SQL server this is realy easy using the XML features and stored procedures.

Christoph

arschr
User
Posts: 893
Joined: 14-Dec-2003
# Posted on: 08-Mar-2006 17:52:02   

alexdresko wrote:

an Oracle junkie ni CompUSA over the weekend. He was quite certain Oracle was faster than SQL in most cases. simple_smile

And if you talk to a SqlServer junkie, he'll be sure of the reverse. wink

Seriously, I doubt that things are all that clear cut.

stoneyowl avatar
stoneyowl
User
Posts: 62
Joined: 29-Jan-2004
# Posted on: 08-Mar-2006 18:06:08   

Our database was on Oracle 8i, and I migrated to SQL Server (when the boss wasn't looking). Many of our tables contain over 4 million records, with three now over 28 million (all active and retired Army service members), and I can say that MS SQL Server improved response time between 2 to 5 fold with no other tuning.