Before creating indexes, measure your application (profile). If you discover the database is the bottleneck and need some covering index (use EXPLAIN in MySQL) then go and make and index.
http://dev.mysql.com/doc/refman/5.0/en/optimization.html http://www.mysqlperformanceblog.com/ http://video.google.com/videoplay?docid=2524524540025172110 http://forge.mysql.com/wiki/Top10SQLPerformanceTips On Sat, Mar 8, 2008 at 10:18 AM, Greg Baker <[EMAIL PROTECTED]> wrote: > > Is it normally good practice to index a HABTM table? If so how do you > do this? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
