yes, i've taken them all out, even the ones that shouldn't have gotten close to my stats_link table
2008/2/21 Jarek Zgoda <[EMAIL PROTECTED]>: > > 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 -~----------~----~----~----~------~----~------~--~---
