That sounds like it is spending time trying to connect to the server instead of doing actual work. Have you tried using a different server? I have tried myself using a windows azure server and it seems to work just fine.
On Tuesday, June 3, 2014 9:34:17 PM UTC+2, Jordan Hopfner wrote: > > I just tried upgrading to PHP 5.4.29, changing the sqlsrv extensions to > 5.4 and the problem still persists. My test page (non-cake) is still speedy > and spits out data instantaneously though. From what I can see there is no > official sqlsrv extension for PHP 5.5 yet. I tried changing the debug level > to 0 so it wouldn't update the caches but it still takes a long time load > data from MSSQL. > > On Tuesday, June 3, 2014 11:13:15 AM UTC-6, José Lorenzo wrote: >> >> Have you tried updating your php version at the latest possible version? >> I've read about this problem multiple times and it was solved every time by >> upgrading the php version. >> >> On Tuesday, June 3, 2014 6:39:50 PM UTC+2, Jordan Hopfner wrote: >>> >>> I'm using MSSQL, not MySQL :). I'm thinking I'm gonna have to shelf Cake >>> on this project unfortunately. >>> >>> On Sunday, June 1, 2014 4:50:07 PM UTC-6, Charlie Topjian wrote: >>>> >>>> I experienced similar problems with my stack. What version of MYSQL are >>>> you using? >>>> >>>> On Wednesday, May 28, 2014 4:19:09 PM UTC-5, 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 cake-php+unsubscr...@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.