Re: Simple controller action takes over 13 seconds

I cloned the DB locally for development and the slow speeds completely went away. I guess there was a lot of overhead connecting to the remote DB other than the query, because the query itself was really fast. I'm not sure I understand what went on there, but I'm good to go now. Thanks for your assistance.

On Tuesday, August 13, 2013 3:44:45 PM UTC-7, Xtagon 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.