I'm not sure what the default format for MySQL tables is when using Rails (I find myself opting for PostgreSQL more and more these days), but I never presume that foreign key indices exist.
-- Pat On 26/05/2011, at 1:56 AM, Samuel Richardson wrote: > Eager loading is in place. Is it correct to assume MySQL handles generating > foreign keys automatically? (I'm going off this article: > http://stackoverflow.com/questions/304317/does-mysql-index-foreign-key-columns-automatically) > > Samuel Richardson > www.richardson.co.nz | 0405 472 748 > > > On Thu, May 26, 2011 at 9:52 AM, Nathan de Vries <[email protected]> wrote: > On 25/05/2011, at 6:22 PM, Samuel Richardson wrote: > > I removed the inclusion of medias when calling genres which has sped > > things up immensely, so whatever it was, was related to that. > > > Make sure you have the correct DB indexes set up for both joining & sorting, > and consider eager loading (via includes) any models that are causing > additional queries. > > > Cheers, > > Nathan > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" 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/rails-oceania?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" 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/rails-oceania?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" 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/rails-oceania?hl=en.
