I've been following this theme for quite some time now and I need to ask:
Why would anyone want to use MSSQL with PHP?
And before anyone starts getting evangelist on me:
Yes, MSSQL could be considered an advantage over MySQL and it is. Sure! But
IT IS NOT THE ONLY OPTION and it is very,very poorly supported if your
application is hosted on Unix/Linux.
Historically, PHP was made to work in the Unix/Linux environment and then
*ported
to MS Win/IIS*. We all know that Microsoft loves to hate the Penguin.
Has anyone used the FreeTDS driver on Linux? I sure have and not by my own
choice. It does not support transactions... Yes! Transactions!!
Why does Microsoft NOT produce a good driver for their DB but for
Linux/Unix?
Why would you want to pay Microsoft's fees if they don't really support
you?
Why would you want to run your code with the disadvantages that hosting it
on MS IIS and still pay them?
The bottom line is: *Microsoft wants to sell their shit* *and for loads of
cash*.
They will do this at any cost and the first thing they do is to push us all
back in the corner - that's why there is no official Unix/Linux driver for
MSSQL. Because they want us to host our shit on their shitty OS and most
importantly *NOT BE ABLE TO HAVE THE CHOICE*.
Sure, I am an Open Source advocate and you can say I am biased. But I can
argue that it is much better for one to be able to have a multitude of
choices that to be given with only one and no laternatives.
That's the problem, ain't it?
So for me, bottom line is if you want a real RDBMS as of Edgar Codd's RDB
theory (and no not MySQL) you still have PGSQL and it goes even further
than that.
PostgreSQL gives us what MySQL (I think) will never be able to and takes so
many steps forward. Even from MSSQL.
A lot of people take the decision to use MSSQL because "that's what they've
used previously" but this does not make it the right choice.
Sure, you may not have a choice now but what about in the future?
So please, think about it and don't get evangelist on me. :)
Best Regards,
Borislav Sabev.
On Thursday, 29 May 2014 00:19:09 UTC+3, Jordan Hopfner wrote:
>
> Hey guys,
>
> I'm using the latest version of Cake (2.5.1) and am having a problem with
> extremely slow connections to a MSSQL server. A controller action that only
> has one simple select statement is taking an upwards of 50 seconds to
> complete. I don't think it's the select statement itself, I have a created
> an empty page that connects to MSSQL via PDO and executes the exact same
> statement and the result is instantaneous, so this leads me to believe it's
> a problem with the MSSQL data source packaged with Cake. If it was a driver
> or connection issue I would assume it would happen on the test page as
> well. Any ideas? I'm on PHP 5.3.x and am connecting to SQL Server 2008 R2.
>
> Jordan
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
