Home » RDBMS Server » Server Administration » Oracle looses against MS-SQL-Server
Oracle looses against MS-SQL-Server [message #49632] Thu, 31 January 2002 22:11 Go to next message
Sabine
Messages: 7
Registered: January 2002
Junior Member
Hello all,
we are now to decide wheather to use Oracle9 or MS-SQL-Server.Net for our application. Our comparisons show that MS is about two times faster than Oracle both in inserts or selects, little or many data. We access the database over C# / OLEDB with the Oracle provider. This result is terrible as we all worked with Oracle up to now and don't want to use MS-SQL-Server.
Can anybody give me a hope, how I could speed up my Oracle9 (dedicated server modus)??
Thanx Sabine
Re: Oracle looses against MS-SQL-Server [message #49646 is a reply to message #49632] Fri, 01 February 2002 04:09 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Oracle9i on NT ? UNIX ?

Speed is just one of the criteria. When you said 'many data' did you mean a couple of millions of rows or not ?
Re: Oracle looses against MS-SQL-Server [message #49650 is a reply to message #49632] Fri, 01 February 2002 05:08 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
have you tried it with one session or several sessions inserting data at the same time?
Which amout of data are you using?
What kind of queries are you runing?
For what will de DB be used to?
Re: Oracle looses against MS-SQL-Server [message #49661 is a reply to message #49632] Sat, 02 February 2002 07:55 Go to previous messageGo to next message
Maurice Mueller
Messages: 1
Registered: February 2002
Junior Member
Hi,

Are you using partitioned or subpartitoned tables? If not have a look at it. In a DWH, if well defined, it may help a LOT.

Have also a look at Bitmap Indexes and Bitmap Join Index (new in 9i) which, depending on the cardinality of the data, may be much faster the normal indexes.

How are you loading the data (insert/import/sqlloader/...) ?

The following document may also help you (Oracle9i Data Warehousing Guide, Release 1 (9.0.1), Part Number A90237-01):
http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90237/toc.htm

Viel Erfolg
Maurice
Re: Oracle looses against MS-SQL-Server [message #49666 is a reply to message #49632] Sun, 03 February 2002 08:39 Go to previous messageGo to next message
Maurice
Messages: 8
Registered: February 2002
Junior Member
The patchset 2072050 (ORACLE9I 9.0.1.2.0 PATCH 1 FOR WINDOWS NT AND WINDOWS 2000) which upgrades to 9.0.1.2 may also improve some performance issues.
Re: Oracle looses against MS-SQL-Server [message #49670 is a reply to message #49666] Sun, 03 February 2002 21:01 Go to previous messageGo to next message
Sabine
Messages: 7
Registered: January 2002
Junior Member
Where can I find this patch???
I searched the whole Oracle site, but couldn't find it :-(
now MS-SQL-Server looses :-) [message #49671 is a reply to message #49632] Sun, 03 February 2002 22:11 Go to previous messageGo to next message
Sabine
Messages: 7
Registered: January 2002
Junior Member
Danke :-)
You are right, we hadn't considered the bitmap indexes so far. But partitioning isn't useful.
In two millions rows there are only 500 different values! I'm now preparing the implementation of these indexes...
After all the tuning till now now Oracle is twice as fast as MSSQL. Gottseidank
But I have to confess that we didn't tune the MSSQL, so it isn't a fair contest...
Re: Oracle looses against MS-SQL-Server [message #49674 is a reply to message #49666] Sun, 03 February 2002 23:36 Go to previous messageGo to next message
Maurice
Messages: 8
Registered: February 2002
Junior Member
You can find it on metalink (metalink.oracle.com). To have access to metalink you need an accout. If you have not such a account check whit Oracle Support or the person which sold you Oracle.

Maurice
Re: Oracle looses against MS-SQL-Server [message #49679 is a reply to message #49666] Mon, 04 February 2002 03:18 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
The Oracle FTP site is

ftp://oracle-ftp.oracle.com

Dig around. All server patches are in

ftp://oracle-ftp.oracle.com/server/patchsets/

Good Luck
Re: now MS-SQL-Server looses :-) [message #49684 is a reply to message #49632] Mon, 04 February 2002 05:39 Go to previous messageGo to next message
Maurice
Messages: 8
Registered: February 2002
Junior Member
I'm suprised that partitioning has not improved the performance in a DWH environement.
Are you sure you have (sub)partitioned the table by a relevant key? Have you used the appropriate partitionning methode (range, hash or list)?
Re: now MS-SQL-Server looses :-) [message #49698 is a reply to message #49684] Mon, 04 February 2002 22:33 Go to previous message
Sabine
Messages: 7
Registered: January 2002
Junior Member
Sorry, my answer was a bit undefined ;-)
Exactly I meant, that I didn't consider to partitionate the tables anyway as there is no relevant key (for a range partitioning). So far. But now I "rtfm" once again and maybe I'll try to use a hash partitioning. Unfortunately the big boss didn't decide until now weather to use standard edition :-( or enterprise edition :-)
But you see: the main decision - MS or Oracle - is done! :-))
Previous Topic: Re: I want to know patch for mts
Next Topic: Re: OracleServiceSID on Win2000 starting, but not started
Goto Forum:
  


Current Time: Tue Dec 24 10:29:30 CST 2024