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
-~--~~~~--~~--~--~---