Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-14 Thread Jordan Hopfner
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 U

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-13 Thread Jordan Hopfner
hanging 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 W

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-16 Thread Jordan Hopfner
Again, I'm using MSSQL not MySQL. I suppose I could give 2.4 a shot, wouldn't hurt to try. On Sunday, June 15, 2014 3:54:54 AM UTC-6, Michael Houghton wrote: > > I suspect this is a MYSQL setting. Out if interest, have you tried version > 2.4 or below? -- Like Us on FaceBook https://www.facebo

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-11 Thread Jordan Hopfner
I haven't tried 3.0 yet. I've been waiting for at least a beta to come out before I try it. On Tuesday, June 10, 2014 11:25:02 PM UTC-6, José Lorenzo wrote: > > Have you tried with CakePHP 3.0, just for curiosity? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http:/

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-04 Thread Jordan Hopfner
> > We've got a full application, doing joins, inserts, etc. Also uses > FileStream. No issues, runs just as fast as MySQL > > On Wednesday, 4 June 2014 15:58:20 UTC+2, Jordan Hopfner wrote: >> >> What kind of tests/queries are you guys doing? Just verifying that you

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-04 Thread Jordan Hopfner
What kind of tests/queries are you guys doing? Just verifying that you can connect or pulling back a bunch of rows? On Tuesday, June 3, 2014 9:57:43 PM UTC-6, Dakota wrote: > > I have no issues with MsSQL and Cakephp 2.5 (migrated to 3.0 dev though > now). Running sql 2012 and php 5.5. > > You c

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-03 Thread Jordan Hopfner
erent 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 prob

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-03 Thread Jordan Hopfner
le 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. &g

Re: Auth returning true always

2014-06-03 Thread Jordan Hopfner
Auth is returning true because you're manually logging in a user by passing in an array. See http://book.cakephp.org/2.0/en/core-libraries/components/authentication.html#manually-logging-users-in. Why are you passing the data in like that, just for testing? On Friday, May 30, 2014 10:33:55 PM

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-06-03 Thread Jordan Hopfner
n 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

Cake 2.5.1 Extremely Slow With MSSQL?

2014-05-28 Thread Jordan Hopfner
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