Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Dakota
Hi Alan, The Query object does not use SQL cursors, but rather buffers the results locally (In PHP land) and builds lists from that. However, CakePHP 3.0 does rely on obtaining the row count (With PDOStatement::rowCount), which return -1 with PDO::CURSOR_FWDONLY

Sistema de Busca

2014-08-15 Thread Wander Arce
Boa noite, Alguém pode indicar um plugin para criar um sistema de busca? Caso não utilizem plugin como fariam??? Att. Wander Arce -- 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

Re: 3.0: a peek into CakePHP's future

2014-08-15 Thread SFranky
I don't think that shift towards ORM is a bad choice. The Model Layer of CakePHP was quite staightforward, but it lacked efficiency in terms of readibility and flexibility. The implementation of ORM might frighten the old folks, accustomed to Active Record Queries, but in the end its a step

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Борислав Събев Borislav Sabev
I've been following this theme for quite some time now and I need to ask: Why would anyone want to use MSSQL with PHP? And before anyone starts getting evangelist on me: Yes, MSSQL could be considered an advantage over MySQL and it is. Sure! But IT IS NOT THE ONLY OPTION and it is very,very

Re: Post idea: Long term, large scales projects with CakePHP

2014-08-15 Thread José Lorenzo
I really like the idea David, CakePHP definitely needs more and better marketing. What I disagree with is that only a core developer or something with a lot of experience can write such articles or help promoting the framework, anyone could start adding their experiences with CakePHP, even

Re: Post idea: Long term, large scales projects with CakePHP

2014-08-15 Thread Stephen S
I'd love to contribute to this also if you wish, so just a little about my experience, I first started using 1.x roughly back in 2006/2007 and the majority of my projects since have been created in CakePHP. I've used other frameworks in between but I have a lot of things to say in favour of

Re: Post idea: Long term, large scales projects with CakePHP

2014-08-15 Thread David Yell
The reason I included the bit about the 'core developer' was because they would have the best understanding of how the core components work and which software design principles they encompass. I do agree that we can all do something to help market the framework, but marketing needs to come from

Re: Post idea: Long term, large scales projects with CakePHP

2014-08-15 Thread David Yell
So I have created the repo and put some placeholder files in there, with a bit of copy. If I need to write about the software patterns I will need to learn the core and learn about software patterns, so that one might take a while. I'll work on the tips and tricks mostly, as long as I can

Re: Post idea: Long term, large scales projects with CakePHP

2014-08-15 Thread David Yell
It would have been super helpful to include the link to the repo, d'oh https://github.com/davidyell/BakeYourDreams -- 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

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Dakota
We usually a exclusive *nix environment. But, we've got two simple reasons as to our choice in SQLServer in the current project: 1. The client requested it. Their existing infrastructure, as well as all their existing systems run in a MS environment. They are not willing, nor can

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Alan Read
Hi Dakota, Thanks for clearing that up! I haven't looked at the source for CakePHP 3 yet so I didn't actually see how they implemented it. I should do more research next time as I don't want to mislead anybody... On Fri, Aug 15, 2014 at 3:32 AM, Dakota waltherl...@gmail.com wrote: Hi Alan,

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread Alan Read
In my case, The decision to use a Linux Web Server and SQL Server was already made and implemented before I arrived. To make matters worse we are still stuck on cakephp 1.3 using the mssql driver :(. The whole reason I ran into the Cursor issue was because I am almost done developing a MS ODBC

Re: Cake 2.5.1 Extremely Slow With MSSQL?

2014-08-15 Thread abhijit kakade
I have simmilar setup linux webserver cakephp 2 and mssql, never seen a performance issue. Only issue is if you tried to connect remote sql server from local.. It works perfectly fine when both apache and sql are on internet. For connectivity Im using pear dblib. Thanks Abhijit On 15 Aug 2014