- if you remove the find from the controller is it loads fast ? - how many queries total show in the sql debug ? - are the model relations creating too many sql queries on the find ? - on remote db it takes time to setup tcp/ip network connections etc etc.. - use 'fields' on find to only grab data from mysql whats needed..
part of the code could be helpful... Andras Kende http://kende.com On Aug 13, 2013, at 3:44 PM, Xtagon <[email protected]> wrote: > Versions: CakePHP 2.3.9 running on Apache 2.2 with PHP 5.4 on Windows. > > I created a new CakePHP app and made a basic controller, model, and view. The > page takes over 13 seconds to load, even for fast database queries. DebugKit > timer shows that all that time is being spent in "Controller action", and the > sql log says the total time for all queries is only 248ms (that's a remote > DB, so that's an acceptable delay for now) > > The default landing page for CakePHP shows all green, database works, tmp is > writable, etc. > > So the bottleneck is not the database, it's the controller. The controller > literally only consists of one find method, and it makes no difference how > many records I'm loading. After the 13 seconds, the page displays correctly. > > What's the best way to debug this? I appreciate your assistance, as I am at > wits end. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.
