right database for the right job

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

fractalvibes wrote:Having a skilled DBA manage, tune, etc. is the more important thing.
Absolutely!
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post 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
ldomingues
Forum Commoner
Posts: 41
Joined: Fri Aug 06, 2004 1:15 pm
Location: Portugal

Post by ldomingues »

hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
Post Reply