My big problem is that I have some tables there are very and very huge. I have add indexes but the situation is not improved much Is someone can suggest me how can I manage very large table with mysql and CakePHP without scaling mysql?
On 21 Set, 17:25, "j0n4s.h4rtm...@googlemail.com" <j0n4s.h4rtm...@googlemail.com> wrote: > In general, besides the noted tips: > - Take a look at lazyloader/lazyloading models > - Do not use Model->recursive > 0, use Containable. You might look > into Translateable as well > - DEBUG sql outputs, see where the heavy load is happening. > > On Sep 21, 9:56 am, "marco.rizze...@gmail.com" > > <marco.rizze...@gmail.com> wrote: > > Hi > > I have developed my web application with CakePHP. > > For the moment I use one Apache server and one MySql server. > > Now I have noted that my application is getting slow because the > > numbers of users is increasing. > > So I have decided that is the time to scale my architecture. > > I have tried to find some suggestions on this forum about how scale > > CakePHP but I haven't found anything. > > Can someone help me about this with some example, link, tutorial etc.? > > Many Thanks > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---