Dave Fowler napisał(a): > I have a phantom query that is just killing my database. I have a > model named Stats and django is executing the equivalent to > Link.objects.all() in my Stats app. > > # Query_time: 20 Lock_time: 0 Rows_sent: 659528 Rows_examined: 659528 > SELECT > `stats_link`.`id`,`stats_link`.`title`,`stats_link`.`url`,`stats_link`.`last_modified`,`stats_link`.`subdomain_id`,`stats_link`.`avg_time`,`stats_link`.`rating`,`stats_link`.`dlevel`,`stats_link`.`visits` > FROM `stats_link`; > > I've combed my code 100 times and cannot find a single place where I > do anything remotely like this. I have almost a 700,000 entries in my > link table and it takes 20 seconds to execute.
Did you check also select_related() calls? This may have large overhead sometimes when not used carefully. -- Jarek Zgoda Skype: jzgoda | GTalk: [EMAIL PROTECTED] | voice: +48228430101 "We read Knuth so you don't have to." (Tim Peters) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" 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/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
