Re: Cake 2.5.1 Extremely Slow With MSSQL?

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