Hi folks, I'm a DB engineer working for Yahoo, and we have a new product using django that I'm onboarding. We see a variety of easily fixed issues, but one major one - there are 21 many-many tables here, yet they have auto increment primary keys. This of course is very slow on any platform, but particularly can't use clustering on innodb (you can't, obviously, use myisam on a production system) and the performance of queries on these tables is severely degraded. I can't onboard them properly until we fix these, but they claim the code throws errors when I do - I can't figure out what could possibly reference the field, but something does. If you have any suggestions on an easy way (they have limited dev resources, and us DBE's can't work on code directly) to remove these references, a setting or a very simple change, I'd appreciate it...also consider this a bug report for future versions.
More info below, but thank you guys Trey Raymond Example, existing: CREATE TABLE `accounts_profile_starred_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `profile_id` int(10) unsigned NOT NULL, `group_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `profile_id` (`profile_id`,`group_id`), KEY `group_id_refs_id_e2f1545` (`group_id`) ) ENGINE=InnoDB; Fixed: CREATE TABLE `accounts_profile_starred_groups` ( `profile_id` int(10) unsigned NOT NULL, `group_id` int(10) unsigned NOT NULL, PRIMARY KEY (`profile_id`,`group_id`), KEY `group_id_refs_id_e2f1545` (`group_id`) ) ENGINE=InnoDB; The table list: accounts_profile_starred_groups accounts_profile_starred_review_requests accounts_reviewrequestvisit auth_group_permissions auth_user_groups auth_user_user_permissions reviews_defaultreviewer_groups reviews_defaultreviewer_people reviews_defaultreviewer_repository reviews_group_users reviews_review_comments reviews_review_screenshot_comments reviews_reviewrequest_changedescs reviews_reviewrequest_inactive_screenshots reviews_reviewrequest_screenshots reviews_reviewrequest_target_groups reviews_reviewrequest_target_people reviews_reviewrequestdraft_inactive_screenshots reviews_reviewrequestdraft_screenshots reviews_reviewrequestdraft_target_groups reviews_reviewrequestdraft_target_people -- You received this message because you are subscribed to the Google Groups "Django developers" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-developers/-/ziyEeocC-9UJ. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
