Check the database without the application, if you can, by issuing queries from the application server to the db server. Use myphpadmin or console, if its still slow you should leave cake aside and concentrate only in the database server.
On Thu, Aug 12, 2010 at 7:34 AM, O.J. Tibi <ojt...@gmail.com> wrote: > Hi Thiago, > > I'll be thinking out loud here, I know you may or may not agree with > me as you're probably more experienced, but I'll still write them down > so you can hopefully get some ideas. > > 1) Caching - Have you tried turning the cache on? Or maybe one caching > engine doesn't work well with your infrastructure and you might want > to change to another engine? > > 2) Table indexes - You mentioned that before you have a 2 ~ 3,5 > response time from the app, it might be possible that you forgot to > add or change indexes in your tables? Data grows exponentially and > your indexes might no longer be relevent. A fast query from the early > days of your database may not be as fast when you have a lot of rows > inserted. > > 3) Column types and joins - The database server takes an additional > toll casting column types of foreign keys included in a join. Try to > check if your key columns are uniform. > > 4) Pulling as much data as practical - While CakePHP's caching is > superb, it can only cache views out-of-the-box. If you want to cache > your queries, pull from the database as much as practical for your > application and store it using the caching engine. If that's not > possible at the moment, set this data to the view before the view is > cached. Doing this, you will be able to do manipulations on your data > set in the view, even after the cache is generated. Remember, *only* > pull out as much data as practically possible. > > 5) Use Containable, if much is too much - More often than not, using > CakePHP's associations and how it pulls records out of a find() will > also get you the associated data with the primary model you're working > on. This may cause a lot unused data being sent over the network, > congesting it and may make your application sluggish. If you're not > using the models associated with your primary model, make sure to mark > them with the Containable behavior and flag the 'contain' key in your > find() and $this->paginate arrays accordingly. > > HTH, > OJ > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.com>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > -- Regards, Zaky Katalan-Ezra QA Administrator www.IGeneriX.com Sites.IGeneriX.com 054-7762312 Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
