Re: Cake 2.5.1 Extremely Slow With MSSQL?

I'm not sure if this is really a good idea.
See:
http://stackoverflow.com/questions/1155211/what-is-pdo-scrollable-cursor

But if you want this find its way into the core, then you can help the core team to get in there.

Help yourself by either:
a) Create an issue explaining everything on GitHub https://github.com/cakephp/cakephp/issues/new
b) Fork the code, change it, prove that it really solves the problem without breaking anything else and create a Pull Request https://github.com/cakephp/cakephp/

Thanks
Marc

Am Mittwoch, 13. August 2014 16:07:26 UTC+2 schrieb Jordan Hopfner:

Thanks Alan, appreciate the help. The project has been put on hold for now but I'll definitely try this change when I go to use SQL Server again. It would be great if the core team would make these changes to Cake :)

On Friday, August 8, 2014 10:30:20 PM UTC-6, Alan Read wrote:

Changing the line:

772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL);

to

772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY);

in the _execute function inside of Sqlserver.php solved this issue for me

On Wednesday, May 28, 2014 5:19:09 PM UTC-4, 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.