I loaded up SQL Server Profiler to have a look at what it's doing. It connects instantly, but is doing some very funny stuff. I performed 3 tests, one with debug set at 2 in core.php, one with debug set at 0, and then my non-cake test page. You can have a look at them here:
Debug set at 2 (2,538 lines): http://pastebin.com/Ry0D6gFq Debug set at 0 (1,865 lines): http://pastebin.com/U697PjxJ My non-cake test page, executing the same query as above (7 lines): http://pastebin.com/uLVkYmRJ By the looks of it, Cake is doing something that's wildly inefficient. I had a look at the source of the Sqlserver.php file but I'm not sure what I'm looking for exactly. On Tuesday, June 3, 2014 2:40:56 PM UTC-6, José Lorenzo wrote: > > 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 [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.
