I have simmilar setup linux webserver cakephp 2 and mssql, never seen a performance issue. Only issue is if you tried to connect remote sql server from local.. It works perfectly fine when both apache and sql are on internet. For connectivity Im using pear dblib.
Thanks
Abhijit
On 15 Aug 2014 20:05, "Alan Read" <aread22@gmail.com> wrote:
-- In my case, The decision to use a Linux Web Server and SQL Server was already made and implemented before I arrived. To make matters worse we are still stuck on cakephp 1.3 using the mssql driver :(. The whole reason I ran into the Cursor issue was because I am almost done developing a MS ODBC Cakephp Datasource (for 2.x) using Microsoft ODBC Driver 11 for Sql Server on Linux (http://msdn.microsoft.com/en-us/library/hh568451(v=sql.110).aspx) and unixODBC.--On Fri, Aug 15, 2014 at 4:59 AM, Борислав Събев Borislav Sabev <borislavsabev@gmail.com> wrote:
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 a topic in the Google Groups "CakePHP" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cake-php/2Vqixc1UGCw/unsubscribe.To unsubscribe from this group and all its topics, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
--
Alan Read
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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment