Page 2 of 2

Posted: Tue Oct 12, 2004 12:38 pm
by hedge
infolock wrote:
hedge wrote:
infolock wrote:if you are willing to pay for it, MS-SQL is probably the best sql db out there.. although Oracle has quite a nifty security setup as well... are you looking for an open-source/free distribution or licensed version? it could vary depending on how much you are willing to spend(if any) and what kind of security you are wanting
You must be joking to rank ms-sql above Oracle. Oracle is in it's own category, it is clearly superior in performance, scaleability and functionality... it's downfall is price.

not at all.. ms-sql is the fastest and best db out there. i think you are blinded by the saying "if it's the most expensive, it must be the best". do some research on the studies between the 2...
uum ok, Have you even used Oracle. Of the people I know that have used both they have the same opinion as I do.

A couple years ago Oracle had a challenge to pay anyone a million dollars if they could make a query run in SQLServer in 1/100th of the time as Oracle... noone collected.

I'm not anti SQLServer, both serve a purpose. We run both here but use Oracle for the heavy lifting.

Posted: Tue Oct 12, 2004 9:34 pm
by fractalvibes
Funny - discussing "which is the best database" almost always becomes like a religious war...;-)

SQL Server, Oracle, DB2 are all fine Enterprise-class databases. None of these are for the casual user. Having a skilled DBA manage, tune, etc. is the more important thing.

fv

Posted: Wed Oct 13, 2004 3:15 am
by patrikG
fractalvibes wrote:Having a skilled DBA manage, tune, etc. is the more important thing.
Absolutely!

Posted: Wed Oct 13, 2004 10:49 am
by infolock
Hedge: actually, i used oracle for about a year at lexmark incorporation when we migrated our user-base from mssql to oracle. it cost the company so much money to simply buy the user-agreements that after it was all said and done, it was probably the dumbest move they could have made. oracle has some nice features, don't get me wrong, but the speed mssql gave us showed up as soon as we went live. as i said, oracle may give you some added bonuses and features, but by no means does it compare to mssql's speed and reliability. if you don't believe me, do some research on lexmark. they even sued oracle because they promised us more speed and reliability with their databases, and instead, we got the opposite. lexmark, once again, is use mssql.

but your argument is 2 fold. you may have been using oracle and your buddies too, but the argument you are giving me is the same as a linux boy and a windows boy arguing on who's os is the better. as a poster above pointed out, it's according to the experience the administrator/users have and whichever works best for their needs. i simply pointed out what i experienced. so, if you want to make this into a flame war, by all means, prove me wrong.


edit : i'll even give you a nice url to visit. you then can argue all you want..

http://www.experts-exchange.com/Databas ... 40462.html

Posted: Fri Oct 15, 2004 9:08 am
by ldomingues

Posted: Fri Oct 15, 2004 10:42 am
by hedge
ldomingues wrote:That's right.

Take a look: http://www.mysql.com/it-resources/benchmarks/eweek.html
we weren't even talking about MySQL, we were talking about MS SQLServer. MySQL is fast but it gives up too much functionality such as transactions, redo logging, stored procs etc. (at least in older versions)

I'm not trying to flame anyone, I guess we've just had different experiences. It does appear that SQLServer has significantly closed the gap to Oracle though.

Posted: Wed Oct 27, 2004 9:42 pm
by fractalvibes
I think the "Big 3" (Oracle, MS SQL Server, DB2) are all pretty close, and getting closer. MySQL seems to be trying to close the gap with their next release. Postgres I know nothing about, except what I have read here, but it seems robust from what I have heard.

Like anything else, there is going to be some tradeoff between price/functionality/robustness/ease of maintenance. Luckily for us developers all of the RDBMS are getting better and better. I feel as though I should bring our DBAs an apple or something every day for the work they do to keep our databases operating effeciently.

fv