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 [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.
