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" <[email protected]> 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 < > [email protected]> 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 >> [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. >> > > > > -- > 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 [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. > -- 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.
