Re: Simple controller action takes over 13 seconds

- 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 <xtagon@gmail.com> 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 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/groups/opt_out.