|Pathologically Eclectic Rubbish Lister|
MySQL vs SQL2000by true (Pilgrim)
|on Oct 22, 2002 at 03:19 UTC||Need Help??|
true has asked for the wisdom of the Perl Monks concerning the following question:
I'm a linux webhoster. We added a Windows box next to our linux box 2 months ago. We added this as a Flash MX streaming server for RTMP requests and possibly a Darwin Streamer. I had no intentions of letting the Win2k box host domains. I love my penguin and so do my domains.
Can anybody explain the price for M$ SQL Server?
$2000 minimum to buy?!
I ask this b/c i have turned 2 new clients away because of it. They rang my doorbell bearing checks for a hosting account but insisted on Win2k and M$SQLServer. After i found out i would have to pay even more money to make my already kinda expensive box run SQL, i was appalled. I told the customers sorry but no dice. Why should I buy a product when a stable open source version is available for free? MS's SQL Server is at the heart of their foundation platform.
I'm aquainted with MySQL. I've got it on my linux web server but the SQL traffic is light. Does anyone have any resources or experiences with these two competing technologies? When i found out SQL charges a CAL license for a limited number of connection, i was floored. Is M$ SQL Server better? Is there a weakness to MySQL i haven't seen yet b/c of my light SQL traffic? When i say better, my query leans towards a hosting solution. Several hosts on 1 machine with heavy SQL traffic. For the purposes of discussion, let's say ten SQL requests every second.
I bring this discussion to the perlmonks b/c i always use perl to access SQL. Also, i thought the SQL decision was one every monk would be making at some point in time.
P.S. I don't mean to omit PostgreSQL, but my ignorance keeps me tongue still.