Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Alan Read
k.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to a topic in the > Google Groups "CakePHP" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/cake-php/2Vqixc1U

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Alan Read
et.microsoft.com/en-us/library/ff628154(v=sql.105).aspx) > > > On Thursday, 14 August 2014 20:00:52 UTC+2, Alan Read wrote: > >> I think the reasoning to use scroll was for future reasonsin CakePHP >> 3 they are introducing a new ORM layer (http://book.cakephp.org/3.0/ >

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-14 Thread Alan Read
t;> >> 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 g

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-09 Thread Alan Read
Hi Jordan, I am having the same issue (cakephp 2.5.3, sql server 2008 r2) and I was able to fix it by overriding the SqlServer driver and changing the following line (line number 772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL); to $prepareOptions += array(PDO::ATTR_CURSO

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-09 Thread Alan Read
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 H