Here is the SQL again it overlap in previous post dont know why it posted twice:
*SELECT* `auto_type`.`id`, `auto_type`.`client_id`, `auto_type`.`category_id`, `auto_type`.`subcategory_id`, `auto_type`.`project_id`, `auto_type`.`title`, `auto_client`.`id`, `auto_client`.`title`, `auto_category`.`id`, `auto_category`.`client_id`, `auto_category`.`title`, T4.`id`, T4.`title`, `auto_subcategory`.`id`, `auto_subcategory`.`client_id`, `auto_subcategory`.`category_id`, `auto_subcategory`.`title`, T6.`id`, T6.`title`, T7.`id`, T7.`client_id`, T7.`title`, T8.`id`, T8.`title`, `auto_project`.`id`, `auto_project`.`client_id`, `auto_project`.`category_id`, `auto_project`.`subcategory_id`, `auto_project`.`title`, T10.`id`, T10.`title`, T11.`id`, T11.`client_id`, T11.`title`, T12.`id`, T12.`title`, T13.`id`, T13.`client_id`, T13.`category_id`, T13.`title`, T14.`id`, T14.`title`, T15.`id`, T15.`client_id`, T15.`title`, T16.`id`, T16.`title` * FROM* `auto_type` *INNER JOIN* `auto_client` *ON* (`auto_type`.`client_id` = `auto_client`.`id`) *INNER JOIN* `auto_category` *ON*(`auto_type`.`category_id` = `auto_category`.`id`) *INNER JOIN* `auto_client` T4 *ON* (`auto_category`.`client_id` = T4.`id`) *INNER JOIN* `auto_subcategory` *ON*(`auto_type`.`subcategory_id` = `auto_subcategory`.`id`) *INNER JOIN* `auto_client` T6 *ON* (`auto_subcategory`.`client_id` = T6.`id`) *INNER JOIN*`auto_category` T7 *ON* (`auto_subcategory`.`category_id` = T7.`id`) *INNER JOIN* `auto_client` T8 *ON* (T7.`client_id` = T8.`id`) *INNER JOIN* `auto_project` *ON*(`auto_type`.`project_id` = `auto_project`.`id`) *INNER JOIN* `auto_client` T10 *ON* (`auto_project`.`client_id` = T10.`id`) *INNER JOIN* `auto_category` T11 *ON*(`auto_project`.`category_id` = T11.`id`) *INNER JOIN* `auto_client` T12 *ON* (T11.`client_id` = T12.`id`) *INNER JOIN* `auto_subcategory` T13 *ON*(`auto_project`.`subcategory_id` = T13.`id`) *INNER JOIN* `auto_client` T14 *ON* (T13.`client_id` = T14.`id`) *INNER JOIN* `auto_category` T15 *ON*(T13.`category_id` = T15.`id`) *INNER JOIN* `auto_client` T16 *ON* (T15.`client_id` = T16.`id`) *ORDER* *BY* `auto_type`.`id` *DESC* * * *below are screenshots * On Wednesday, 26 September 2012 09:33:02 UTC-4, rentgeeen wrote: > > I am sorry I post the old one here is the update: > > Screenshot: > > http://cl.ly/image/2A3z1q2l053l > > Screenshot of Admin clicking on TYPES = 60 seconds to load this is the > query > > http://cl.ly/image/1G1S0c0r302s > > if I remove from admin "list_display > > class ProjectAdmin(admin.ModelAdmin): > > list_display = ('client', 'category', 'subcategory', 'title', ) > > admin.site.register(Project, ProjectAdmin) > > all foreign keys then in admin all works super fast. > > > *SELECT* `auto_type`.`id`, `auto_type`.`client_id`, > `auto_type`.`category_id`, `auto_type`.`subcategory_id`, > `auto_type`.`project_id`, `auto_type`.`title`, `auto_client`.`id`, > `auto_client`.`title`, `auto_category`.`id`, `auto_category`.`client_id`, > `auto_category`.`title`, T4.`id`, T4.`title`, `auto_subcategory`.`id`, > `auto_subcategory`.`client_id`, `auto_subcategory`.`category_id`, > `auto_subcategory`.`title`, T6.`id`, T6.`title`, T7.`id`, T7.`client_id`, > T7.`title`, T8.`id`, T8.`title`, `auto_project`.`id`, > `auto_project`.`client_id`, `auto_project`.`category_id`, > `auto_project`.`subcategory_id`, `auto_project`.`title`, T10.`id`, > T10.`title`, T11.`id`, T11.`client_id`, T11.`title`, T12.`id`, T12.`title`, > T13.`id`, T13.`client_id`, T13.`category_id`, T13.`title`, T14.`id`, > T14.`title`, T15.`id`, T15.`client_id`, T15.`title`, T16.`id`, T16.`title` > *FROM* `auto_type` *INNER JOIN* `auto_client` *ON* (`auto_type`.`client_id` > = `auto_client`.`id`) *INNER JOIN* `auto_category` > *ON*(`auto_type`.`category_id` > = `auto_category`.`id`) *INNER JOIN* `auto_client` T4 *ON* > (`auto_category`.`client_id` > = T4.`id`) *INNER JOIN* `auto_subcategory` *ON*(`auto_type`.`subcategory_id` > = `auto_subcategory`.`id`) *INNER JOIN* `auto_client` T6 *ON* > (`auto_subcategory`.`client_id` > = T6.`id`) *INNER JOIN*`auto_category` T7 *ON* > (`auto_subcategory`.`category_id` > = T7.`id`) *INNER JOIN* `auto_client` T8 *ON* (T7.`client_id` = T8.`id`) > *INNER > JOIN* `auto_project` *ON*(`auto_type`.`project_id` = `auto_project`.`id`) > *INNER JOIN* `auto_client` T10 *ON* (`auto_project`.`client_id` = > T10.`id`) *INNER JOIN* `auto_category` T11 *ON*(`auto_project`.`category_id` > = T11.`id`) *INNER JOIN* `auto_client` T12 *ON* (T11.`client_id` = > T12.`id`) *INNER JOIN* `auto_subcategory` T13 > *ON*(`auto_project`.`subcategory_id` > = T13.`id`) *INNER JOIN* `auto_client` T14 *ON* (T13.`client_id` = > T14.`id`) *INNER JOIN* `auto_category` T15 *ON*(T13.`category_id` = > T15.`id`) *INNER JOIN* `auto_client` T16 *ON* (T15.`client_id` = > T16.`id`) *ORDER* *BY* `auto_type`.`id` *DESC* > * > * > Clicking on PAGES time out cause it has more FKs* > * > On Wednesday, 26 September 2012 03:59:02 UTC-4, Jani Tiainen wrote: >> >> Your query clearly indicates that you're still doing foreign keys >> against TITLE fields, which are strings. So something is definitely >> still incorrect in your models. >> >> Make sure that your foreign keys really point to ID field (basically >> that is leaving out >> >> 26.9.2012 9:24, rentgeeen kirjoitti: >> > I postet the query above in the 1st post, it takes like 17secs, 1 of >> > them like 60 secs >> > >> > |SELECT `auto_type`.`id`, `auto_type`.`client_id`, >> > `auto_type`.`category_id`, `auto_type`.`subcategory_id`, >> > `auto_type`.`project_id`, `auto_type`.`title`, `auto_client`.`id`, >> > `auto_client`.`title`, `auto_category`.`id`, >> `auto_category`.`client_id`, >> > `auto_category`.`title`, T4.`id`, T4.`title`, `auto_subcategory`.`id`, >> > `auto_subcategory`.`client_id`, `auto_subcategory`.`category_id`, >> > `auto_subcategory`.`title`, T6.`id`, T6.`title`, T7.`id`, >> T7.`client_id`, >> > T7.`title`, T8.`id`, T8.`title`, `auto_project`.`id`, >> > `auto_project`.`client_id`, `auto_project`.`category_id`, >> > `auto_project`.`subcategory_id`, `auto_project`.`title`, T10.`id`, >> > T10.`title`, T11.`id`, T11.`client_id`, T11.`title`, T12.`id`, >> > T12.`title`, T13.`id`, T13.`client_id`, T13.`category_id`, T13.`title`, >> > T14.`id`, T14.`title`, T15.`id`, T15.`client_id`, T15.`title`, >> T16.`id`, >> > T16.`title` FROM `auto_type` INNER JOIN `auto_client` ON >> > (`auto_type`.`client_id` = `auto_client`.`title`) INNER JOIN >> > `auto_category` ON (`auto_type`.`category_id` = >> `auto_category`.`title`) >> > INNER JOIN `auto_client` T4 ON (`auto_category`.`client_id` = >> T4.`title`) >> Above is join from auto_category to auto_client "title". >> >> If your model would be "right" it should be autocategory.client_id = >> T4.id. >> >> >> > INNER JOIN `auto_subcategory` ON (`auto_type`.`subcategory_id` = >> > `auto_subcategory`.`title`) INNER JOIN `auto_client` T6 ON >> > (`auto_subcategory`.`client_id` = T6.`title`) INNER JOIN >> `auto_category` >> > T7 ON (`auto_subcategory`.`category_id` = T7.`title`) INNER JOIN >> > `auto_client` T8 ON (T7.`client_id` = T8.`title`) INNER JOIN >> > `auto_project` ON (`auto_type`.`project_id` = `auto_project`.`title`) >> > INNER JOIN `auto_client` T10 ON (`auto_project`.`client_id` = >> T10.`title`) >> > INNER JOIN `auto_category` T11 ON (`auto_project`.`category_id` = >> > T11.`title`) INNER JOIN `auto_client` T12 ON (T11.`client_id` = >> > T12.`title`) INNER JOIN `auto_subcategory` T13 ON >> > (`auto_project`.`subcategory_id` = T13.`title`) INNER JOIN >> `auto_client` >> > T14 ON (T13.`client_id` = T14.`title`) INNER JOIN `auto_category` T15 >> ON >> > (T13.`category_id` = T15.`title`) INNER JOIN `auto_client` T16 ON >> > (T15.`client_id` = T16.`title`) ORDER BY `auto_type`.`id` DESC| >> > >> > |what do you mean by back-end?| >> > >> > python, django, centos6 64bit server, mysql >> > >> > all works fine also on website + admin but only that part if I click >> each table in admin which are defined in admin.py >> > >> > | |class ProjectAdmin(admin.ModelAdmin): >> > >> > | >> > list_display = ('client', 'category', 'subcategory', 'title', ) >> > >> > admin.site.register(Project, ProjectAdmin)| >> > >> > |the more I add FK's to list display and you click that PROJECT table >> or others the view of it in admin is making that query and takes so >> long....if I make it just:| >> > >> > | class ProjectAdmin(admin.ModelAdmin): >> > list_display = ( 'title', ) >> > >> > admin.site.register(Project, ProjectAdmin)| >> > >> > NO FKs then it runs in 0.01ms >> > >> > Screenshot: >> > >> > http://cl.ly/image/3w3D3g0h3h1A >> > >> >> Also I wonder does admin run one query for each FK per row.. >> >> > >> [snipsnip] >> >> >> -- >> Jani Tiainen >> >> - Well planned is half done and a half done has been sufficient before... >> > -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/30KvB1JZCmIJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
