For InnoDB tables, adding a foreign key automatically creates an index, unless you explicitly tell it to use an existing index.
It's easy to end up having duplicate indexes because of this gotcha. Sincerely yours, Olexandr Melnyk http://omelnyk.net/ On Tue, Dec 16, 2008 at 6:18 PM, Liebermann, Anja Carolin <[email protected]> wrote: > > 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: [email protected] [mailto:[email protected]] 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" > <[email protected]> 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: [email protected] [mailto:[email protected]] 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
