Hi Pyrite, When you have an additional index on your foreign keys e.g. foo_id in your table kikis then your connecting datasets are found much faster.
In Mysql you do it like this: ALTER TABLE `kikis` ADD INDEX (`foo_id`) Hope that helps! Anja -----Ursprüngliche Nachricht----- Von: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] Im Auftrag von Pyrite Gesendet: Dienstag, 16. Dezember 2008 16:28 An: CakePHP Betreff: Re: Very slow response times with CakePHP How do you index foreign keys, what does that mean? I am using Postgresql. An example with MySQL will help too. On Dec 16, 8:36 am, "Liebermann, Anja Carolin" <anja.lieberm...@alltours.de> wrote: > Hi GeneSys, > > Have you indexed your foreign keys in your database properly? For our project > that was a real performance boost! > Do you use requestAction a lot? I removed it nearly everywhere by now and > have fat models instead. > > Anja > > -----Ursprüngliche Nachricht----- > Von: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] Im > Auftrag von GeneSys > Gesendet: Dienstag, 16. Dezember 2008 15:10 > An: CakePHP > Betreff: Very slow response times with CakePHP > > Hey Folks! > > So I'm using CakePHP for a couple of months now. The company I am working at > asked me to write a new web portal for them, so I thought, "Well, Cake could > make it!" > > After spending some hours the website was (nearly) finished and so I put it > on the webspace the old webpage was at. > > I already noticed during development that the site requests took about > 3 - 5 secs until the page displayed, but I thought this is due to my > development environment (i just installed the XAMPP from apachefriends with > all default settings), but after uploading the website on the host it got > even worse. > > Request times are between 4 to (up to!) 15 secs. Which is really .. > too slow for a business website. I also tried to cache a lot of database > requests so I limited most of the page calls to only 3 or 4 queries. But > still load times are as high as they were before. > > So there are some facts about my project: It is just a small project ... > - Core > - 1 Model, 1 Controller, some views > - 5 Plugins: Often containing nothing more than a model and a > controller > - intended use: about 1000 visitors per month > > So i don't have the faintest idea why cakePHP is running that slow? > > Probably someone could take a look at the > website:http://www.eurolyser.com/v4/ > (cakePHP)http://www.eurolyser.com/_new/(old website, plain PHP and > html) and tell what could be the problem about the high load times? > > I don't know which configuration settings to post and due to security > concerns I just don't want to publish the whole cake config or phpinfo. But > if any information is necessary needed please don't hesitate to ask. > > Thank you all in advance guys! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
