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 [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.
